Hi,
Is using an unbound form the only way to insert into 2 tables at the "same" time?
I am creating a "Add Candidate" form that my user can add a candidate to a position. The table design includes a CANDIDATE, CANDIDATE_POSITION, and POSITION (with a m-m relationship). The main form is based on the POSITION table, so when the user selects a 'Add Candidate' Button, the pop-up form would allow them to insert necessary data. Except, I would like them to insert this data into both tables without needing to add a candidate first then associating that candidate with the position. Instead, I would like to (if possible) populate the CANDIDATE_POSITION.Position_ID with an argument passed from the mainform, then insert into both other tables via a button click.
Is the best way to do this via an unbound form? Or are there any better alternatives?
P.S. - I'm familiar with SQL so would insert into CANDIDATE before inserting into CANDIDATE_POSITION.
Thanks!
Skid