Hello,
i know this answer is out there, but when I changed jobs I lost all my bookmarked solutions.
Basically
table A Products
table B Subassemblies
Table C Prod_Sub link table
table c is the Many:Many relationship between Products and their sub assemblies.
So I want to have a form that I select a Product, then a sub assembly, and have the form update the link table. As I said, I had a working version of this before, but have since lost the DB/
I do remeber that it involved creating a Query that linked the three tables and using the form wizard to base a form on this query.
thanks
Steve