Good Morning All,

Probably simple, but alluding me. For the following tables, I have set up a "Parts" form with a subform. I want to the subform to show input boxes for all possible locations in table "Locations" for each part selected, and then store any inputs into table "Part-Location". I know how to show all locations already stored in Part_Location, but I want to show all locations in table "Locations". I have tried several things that display all the input boxes, but the query does not allow good.

The three tables....
Parts ---one to many---- Part-Location----one to many----Location

In the past, I used a query to generate all possible combinations and store it in Part_Location. This works, but does not seem very slick.

Thanks for your help,