Filtered lookup

Josetxo

Hello,

I have a form on which I inserted a lookup to the Employee table. I would like to filter the lookup, according to the value of one field int the Employee table.

How can this be done?

Thanks in advance,
Josetxo

vijay_g

hi,
when you define table relation of field property as there is also table filter so you can define filter with lookup.

Vijay Gupta

Josetxo

Works like a charm. Many thanks.