Nov 7 2008, 11:04 AM
I can't seem to get my head round this problem.
The attached diagram should explain what i wish to achieve.
I have managed to get main form and subform 1 working and in sync ie every time main form record changes it shows the corresponding subform1 records.
My problem is subform two's data is derived from an intersection table (many to many) and obviously when i come to insert the subform 2, there are no linking fields (Master/Child) for the sub to link with.
Any ideas please?
Nov 7 2008, 11:23 AM
Try basing subform2 on a query that joins tblSUpplierToProducts to table Supplier.
Nov 7 2008, 01:24 PM
Hi thanks for the tip. I got round it by using for SubFrm2 a form within a form and then used that as subfrm2.
I tried doing this with a query as you suggested but it didnt seem to work, that's because of me i'm sure but thank you anyway.
Nov 7 2008, 01:57 PM
You should really do it the way Douig suggested
The subform should be based on a query that uses your tblSUpplierToProducts
You should select all fields from this table
You can then create a subform using the Wizard and link Master/Child on SupplierID
My 2 cents worth
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here