Updating IDs Using Junction Tables Without Combo Boxes

[danftz]

All,

I am currently working on creating an input form that is designed to have
contact information entered on one side of the form and land parcel
information loaded into the other. The Contact information would be stored in
the contact table, and the parcel data in a parcel table. I have a junction
table, Owner that is designed to hold the Contact ID and the Parcel ID.

My question is this, once the data is entered, how do I get the Owner table
to populate with the proper IDs? I have previously created a database that
used combo boxes, thus setting the IDs by that choice, but I don't know which
controls to attach this to with all free form entry.

Also, to complicate things (yeah.it's never that easy), I would like the
parcel entry to be a subform that is a datasheet so that multiple parcels can
be entered when a contact is added.

Any and all help on how to do this is appreciated.

thank you.

Dan

 

[Jeanette Cunningham]

Hi,
here is the general idea of form set up for data entry when you have 2 table
linked with a junction table.
This way there won't be any missing ID's.
Use a main form in single view for one of the Many side tables.
The main form has a continuous subform bound to the junction table with the
Link Master set to the main form's PK field. This subform has at least one
visible control that is a combo box bound to the second table's PK field.

Jeanette Cunningham

 

[danftz]

Thanks much. I ended up creating a form using the wizard that added a data
sheet of the second table, thus automatically connecting it to the junction
table.

I will be posting my next problem soon.