Table Relation Filter Lookup

Lynx

Hi, firstly thank you for this forum, it has solved may of my problems in the past as I try and learn Nav.

Hoping someone can help, I am trying to create a table lookup field to filter specific items for selection.

Item | Category | Group | Customer
Item1 | CategoryA | GroupA | Customer1
Item2 | CategoryA | GroupB | Customer2
Item3 | CategoryA | GroupC | Customer2
Item4 | CategoryB | GroupD | Customer3
Item5 | CategoryB | GroupE | Customer3
Item6 | CategoryB | GroupE | Customer4
Item7 | CategoryB | GroupE | Customer4

basically I would like to show all results for Category B and all results for Customer 2. I have entered the table relation to filter category B but do not know to to also add customer 2 to the list results. I don't mind entering a CAL command.

Appreciate any assistance.

vaprog

You can not create a filter with an OR between fields in NAV (ie: (Field1 = X) OR (Field2 = Y))
The options that come to my mind are:

• use a form with a temporary table
• Use MARK and MARKEDONLY
• Use the OnFindRecord and OnNextRecord triggers on the form to filter the table