Show lookup based on boolean

divyesh10

I have created a boolean in structure table . and i have made lookup of that structure table in purchase order page.
i want to show only those field on lookup of purchase order page where boolean is true . How can i do that?
i m new to navision

mohana_cse06

The structure values are showing based on Table relation property set on Structure field in Purchase Header table.
Go to the property and set Table Filter on the Table relation property

divyesh10

Sir actully i have created three boolean .
Raw material , store and fuel.
so if raw material boolean is true then in purchase order of Raw material it should only display the record whose boolean is true for raw material.

mohana_cse06

For Purchase Orders only Raw Materials should show always?
or is there any field in Purchase order based on which list should show?

divyesh10

yes there is a field purchase type in purchase order
i have to set as if purchase type = Raw material
then in lookup of structure in Purchase order page it should only display that record of structure whose Raw material boolean is true.
if purchase type = Store
then in lookup of structure in Purchase order page it should only display that record of structure whose Store boolean is true.

mohana_cse06

Then you need to use Conditions also in Table relation Property
Check No. field in Purchase Line table for example.

divyesh10

IF (Purchase Type=FILTER(DEBIT-NOTE)) "Structure Header" WHERE (Debit-Note=FILTER(Yes)) ELSE IF (Purchase Type=FILTER(CAPITAL)) "Structure Header" WHERE (Capital=FILTER(Yes))
is this correct? Sir

mohana_cse06

Test it in Test Database and let us know the result.

divyesh10

thanks alot for your help sir..
it works