my question is how to link a form to a subform so that depending a choice made in the form, the data in the subform adapts accordingly.
Two tables :
The relationship between the tables is made by ID (table Product) and ProductID (table contract) with enforce ref. integr.
I would like to have a form with in the main form a combobox with the names of the products and a subform beneath that will give all the clientsinfo based upon the choice made in the productname.
So, say they are two products WWS and WWP.
I choose WWS in the main form and the subform gives me all the clients who have this product. I can add or change this info.
Afterwards I choose WWP etc...
Can anybody give me some good advice on how to program this...?