adding to two tables in one query

  • Thread starter Thread starter aa
  • Start date Start date
Not in Access.

--
Duane Hookom
MS Access MVP


Is there a syntax for INSERT to add records to two tables in one go?
 
Thanks, but how this fits into the database integrity supported by Access?
If i have two related tables I am supposed to add date to both of them at the same time?
Not in Access.

--
Duane Hookom
MS Access MVP


Is there a syntax for INSERT to add records to two tables in one go?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No. To maintain referential integrity (which is what you are
describing) you add data to the non-dependent table first & then to
each table further down in the dependency chain. IOW, if there is a
Sales table that uses EmployeeID, there must be an EmployeeID in the
Employees table before that EmployeeID can be entered into the Sales
table. This is usually a 1 to many relation - the 1 being the
Employees table and the many being the Sales table.

In Access Help read the article "About relationships in an Access
database." Index search keyword "referential integrity."

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEZLmoechKqOuFEgEQKHZACeO0yCqfROWgBJkNxfk/YZIkd3rAsAoOuw
e3oa65JtuAHUDNX2r0KFIUXE
=uDVN
-----END PGP SIGNATURE-----
 
Back
Top