I am new to this forum, but I am very glad to be here.
I'm needing some help with the design of my database. The primary table has a total of six relationships with other tables: three one to many, and three many to many joined with junction tables.
Where I'm struggling is the creation of my master form. The three one to many relationships will be represented with combo boxes; all the records will be created on their own forms. But the three other many to many tables are causing issues for my main form. I want to use subforms where the user will create the records for these tables as they complete the master form.
I think my main issue is the how to link the records created in the subform to the primary table while in the master form.
I know my master form should be based on a query, but I'm also having trouble designing the correct query for it.
I'm willing to provide a copy of my DB if needed.
I'd appreciate any assistance you can provide.