Table Relation Filter

Soloper

Hi all;

I have a field in a table and there is a filter in it.

Filter is something like that :

No.=FILTER(A*).

And this is the hole TableRelation string :

Vendor.No. WHERE (No.=FILTER(Y0*))

Ok it works when I lookup in the field but filter doesnt work and it gets all the records on vendor table.

Anybody can suggest something?

Thank you.

vijay_g

you can not assign a filter to the primary key rest of the all fields.
try this on other fileds it will work better.