FM7: Value list based on indirect relation

[Beat]

I'm sure this sort of question has been asked before, but I'm unsure what search terms to use, so please forgive me if this is old stuff:

Let's say I have a table INVOICES and a table LINES which are related via the key field ID. INVOICES has a field LANGUAGE and LINES has a field UNIT. Now I would like to define a value list which will show all values of UNIT for records in LINES which are related to records in INVOICES with the same language, so when I tab into UNIT, I will get a pop-up list of all units that I have previously used in lines of invoices of the same language. Is this feasible dynamically (i.e. without using a lookup LANGUAGE field in LINES)?

Cheers, Beat

[Henke]

Nope. You need to have a LANGUAGE field in the table LINES.

/Henrik

[Beat]

Thanks. Better a negative conclusive answer than none at all

Beat