Idea on more than one many-to-many relationships on a form/subform.

[Mythran]

I have sales where one sale can have one or more products. Each product for each sale can be a size defined in another table.

On the form we need to have the user select up to 5 products at once, from a list of products.
The form will also need to allow the user to select the size of the product, up to 4 times (so a product can be broken down into 4 separate sizes), along with a quantity for each size.



I have tried this with sub-forms...within a sub-form...on the main form, and it looks tacky with all the different navigational bars to move between records, in each sub-form. So, I'm asking y'all for some tips / pointers on how to make it look more professional.

[SoftwareMatters]

You could link the size table to the products table 4 times i.e. Size1, Size2, Size3 and Size4.
Then in your suboform you could select the required sizes for each product on one line.

[Mythran]

Thanks, I will give it a shot. If this doesn't work, I'll created a C# application...much quicker for me since I'm do that for a living...not Access