Many to many data entry question

[CharlieC]

Hi

I've attached a simplified version of the relationship between some of the tables I would like to use in a database but am having trouble creating the form(s) for data entry.

Basically I have a sales order table where one sales order can be made up of many batches of a product. Each batch has a set of results (in the results table) however each of these batches can appear in more than one sales order.

I have tried several ways of setting it up, the one that seemed closest to being successful was by creating 2 forms (a sales order form and a batch results form) each of which was completed and then the idea was that the results would be displayed in a 3rd table with the batch results at the top and the applicable sales orders shown below in a subform. However the junction table was empty and the subform wouldn't work.

I am guessing I am setting the subform up wrong? Or has it gone wrong long before this point?!

I would be extremely grateful for any pointers!

 

[georgedwilkinson]

One of the tables on the outside of the M:M relationship goes in the main form. The junction table goes in the sub-form. Using this strategy, you have 2 different ways to see and/or manipulate your data. See Pat Hartman's M:M sample on this site.