How to Filter Subtable Field Based on Field Selected In Main App

[bethany.k]

I have an application with a subtable. When I enter a value in the “Ledger” field, I want to filter the “GL Header” table lookup field to show only records with that same ledger. Is there a way to do this?

One idea I had was to add the “Ledger” field to the subtable and populate it on FVC (field value change) of the “Ledger” field. Then I could apply a filtered TL on the “GL Header” based on that. However, this approach does not seem performant.

Is there a better or more efficient way to achieve this?

[calvin.fisher]

The platform only supports filtering subtable table lookups with other subtable fields. I think the best approach would be to add the Ledger field to the subtable, and then set it up as a Common Field so it inherits the value of the Ledger field on the main table. That way, you don’t have to programmatically keep the values in sync - the platform will do it for you.