Can I add multiples with a One to Many

[carriey]

I am feeling soooo frustrated with this but I am sure it's super easy. I
have a ton of subtables that all have One to Many Relationships with the
Tbl_MAIN. Tbl_MAIN essentially houses location info.

The data entry forms are all on tabs as subforms with the Tbl_MAIN data as
the main form. They all function the same way one job function per location,
that you can add multiple records to (ie. many inspections, many events...)

One of my tables is for Self-Declarations and it also needs to be set up
this way in a subform of the main form (and is, and works fine) however,
there are many occasions where we have one Self-Declaration for multiple
locations (so the reverse).

What I have been working at all day unsuccessfully is trying to build a form
that allows you to add the Self-Declaration data (just as you would in the
Main form if it was one location) but then add multiple location records in a
subform. In reading through the help, I thought that maybe I need a Junction
Table so I set that up with RecordID and ObligID and made two one to many
relationships to the Junction Table.

I'm not sure where to go from here.....I assume I should delete the previous
one to many I had set up between the two tables? Do I now just include the
junction table in all my queries and voila or should I actually be adding all
my fields to the junction table? Thanks so much!

 

[Arvin Meyer [MVP]]

What you are looking for is a Many-to-Many table structure which uses a join
or intersect table. The OrderDetails table in the Northwind sample database
that came with Access is a sample. Look at the relationships and how they
are set up (Tools >>> Relationships) and you'll see how to do it.