Adding new record...

[pierrewhy]

I am creating a new record on a table of Access DB using VB.Net Express 2005.
The PK is the same for all my other 10 tables.
I there a way to update my other tables with the newly created key from my Form1.
I am not using Datagrid. Only text boxes.

Thank you,
Pierre

 

[cjard]

The PK is the same for all my other 10 tables.

Then they should all be in one table


in databases, we do this:

TBLPERSON
ID, firstName, lastName, address, zipCode, phoneNumber, accountBalance


not this:
TBLPERSONFIRSTNAME
ID, firstname

TBLPERSONLASTNAME
ID, lastname

TBLPERSONADDRESS
ID, address

TBLPERSONZIPCODE
ID, zipcode

TBLPERSONPHONENUMBER
ID, phoneNumber

TBLPERSONACCBAL
ID, accountBalance

...

know what I mean?