Three table data entry form

[jennifer.quack]

Hello,

I have created three tables: a Person table, a Guardian table, and a
PersonGuardian table. The PersonGuardian table is made up of just 2
fields - a foreign key to a PersonId and a foreign key to a
GuardianId. (If a person is over 18, the "Self" record would be the
Guardian; several children from the same family may have the same
guardian, etc - that is why a seperate table with just the 2 fields in
it. Trying to get to 3NF.)

Anyway - how do I create a form that allows entry of a new person with
a drop-down showing existing guardians from which a name may be
chosen, and then populates the two ids (the person id being just newly
generated) in the PersonGuardian table? I've been trying subforms but
not getting anywhere...and trying to stay away from code....

Thanks for any help,
Jen Q.

 

[jennifer.quack]

Never mind. I'm a moron! Up too late! Sorry for wasting anyone's time.
I just created a main form with the Person data, then ONE subform with
the PersonGuardian data (PersonId hidden, GuardianId as drop-down with
Guardian info in it). Ignored Guardian table altogether. Works fine.
Again, DUH. Wow. I'm going to bed....

Jen Q.