Table relation with selected records only


I do have a field with table lookup in which it shows all the records of the lookup table. The lookup table has fields F1,F2,F3 and Active (boolean). What I want is to display is only the records where Fieldname Active is true. Can this be achieved from Tablerelation where Clause? If so how can it be done?

Thanks and Regards.

Use the table filter property. For example, to limit the lookup of “Production Orders” to only released orders. “Production Order” WHERE (Status=CONST(Released))

Thanks so much bbrown. Your suggestion helped me to find a solution for my problem. With the following code, I can filter the records where Active = true.

 TableRelation = "Webstore Category"."Category ID" where(Active= const(true));