G
Guest
My system needs a junction table between tblPersons and tblProjects so I can
assign people to projects (and hopefully add a "role" as well). Therefore, I
think I need a junction table using the projectID and the personID from each
of those primary tables (both fields, respectively, are the individual PKs in
those tables) as the composite PK for my junction table, and then I'll add in
a "projectRole" field in the junction table as well.
All that I think (hope) is ok. What I can't figure out (and it's a broader
question than just with the junction table but the junction table is a good
example) is how one populates more than one table with "one" form. Can one
form populate more than one table simultaneously? Does it have to be based
on a query or something? Does it have to be a form/subform setup or
something?
In any of those cases that might work, do you end up with the user putting
the same piece of information in the same form TWICE just so you can parse it
to two different tables? I just don't know how this works and even a little
direction would be helpful.
Thanks,
cheese W
assign people to projects (and hopefully add a "role" as well). Therefore, I
think I need a junction table using the projectID and the personID from each
of those primary tables (both fields, respectively, are the individual PKs in
those tables) as the composite PK for my junction table, and then I'll add in
a "projectRole" field in the junction table as well.
All that I think (hope) is ok. What I can't figure out (and it's a broader
question than just with the junction table but the junction table is a good
example) is how one populates more than one table with "one" form. Can one
form populate more than one table simultaneously? Does it have to be based
on a query or something? Does it have to be a form/subform setup or
something?
In any of those cases that might work, do you end up with the user putting
the same piece of information in the same form TWICE just so you can parse it
to two different tables? I just don't know how this works and even a little
direction would be helpful.
Thanks,
cheese W