Hi,
Could anyone please tell me if this is possible (and how). I have a Master-Detail form and I need to control the content that can be selected in the detail part of the form.
The master contains a field “supplier” which looks up data from a table “company” and saves the data in a table called “order”.
The detail contains a field “product” which looks up data from a table “materials” and saves the data in a table called “order_detail”
At present the field “product” lists all of the entries in the “materials” table. I want to be able to restrict the list to only the products offered by the value selected in the “supplier” field.
The “materials” table also contains a field “supplier” where it stores the same value as the field “supplier” in the “company” table.
