Hi
Im trying to filter a lookup based on Master table value.
I have an Invoice Table with customer number field and Invoice line with Buildings, Apartments. I want to filter the apartments based on customer number on MASTER invoice table.
In other words When I add an Invoice I select Customer No. 10 them in the invoice line I select Building 5 and I want to display only Apartment number belonging to Building 5 and only the ones belonging to customer 10.
I could filter the Apartments by Buildings but I don't know how to "Where customer = 10" since Customer variable is not available.
Thanks or your help