Lookup table filter

Gil

Hi,

Is it possible to filter from a lookup table? I can't seem to filter any records, instead it just displays all the recors of that table.
If its not possible what is my alternate solution to looking up then filtering.

Regards,
Gil

mohana_cse06

Can you be more where clear?
You need it on table or field?

Gil

I have this on a menu button:

Yes	List	F5	LookupTable

Then that button runs the lookup table.
When the form runs and i try to filter a field, it won't filter.

mohana_cse06

1. You can filter on Base card form and press F5, it will show filtered records
2. You can write code on OnOpen Form trigger of List form

Gil

how about when filtering fields on that form, it wont work if i press f7 and filter.
It must have something to do with lookup

mohana_cse06

You mean on List form?

I simply opened Item card and pressed F5, it opens Items list form

Now I can put filter on Fields of List form.

Can you try please..

Gil

i found the cause of it, it was when the lookupmode was set to yes, which made me unable to filter record.