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?

Thanks

Paul

Try basing subform2 on a query that joins tblSUpplierToProducts to table Supplier.

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.

Paul

Hi Paul

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

Mike