Adding new record...

pierrewhy

Member
Joined
Oct 4, 2005
Messages
14
Programming Experience
5-10
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

Well-known member
Joined
Apr 25, 2006
Messages
7,053
Programming Experience
10+
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?
 
Top Bottom