2 inserts with differing IDs?
Hi, hope this make some kind of sense, using DA I have a form which on submit inserts values to two tables. tbl1 is a contacts table whereby it adds a contact and contactid [autonumber], tbl2 is an events table whereby it creates a diary event, contact name, conactid and eventid.
Is there a way I can have identical ContactID in both tables to bind the contacts? When insert into tbl1.contactid the ContactID is say 100, insert into tbl.contactid sets its as next number which could be 12, would be great to have both tables store same.
tbl1 - 100 - John Smith
tbl2 - 100 - John Smith
I had thought maybe inserting to tbl1 first then somewhow using a session to insert the newly created ContactID into tbl2.conactid field?