I have two tables with the columns
clientId[FK] clientId [PK]
I made a form with textfields
and I want thru Insert Recordset wizard to pass the cliendId in both tables.
How can I do this?
You can do this by not relying on the recordset wizard and simply coding it yourself to INSERT data to tables. Or use wizard to insert into one table and modify code to allow insert into two tables.
Retrieving data ...