Adding one entry to more than one table at once.

[Tolpless_Mopar]

Hi, this is my first post.

So, my problem. I have created a database and I have the same primary key(SITE) for more than one table. I can not seem to figure out how to create a query to add an entry to all the tables that have site as the primary key. Also, I am running Access 2003 Can somebody help me out?

[June7]

So these tables have a 1-to-1 relationship? These key fields are number type - not autonumber?

Regardless of relationship, one table needs to act as 'parent' and the others are dependents. Then use a form/subform arrangement for data entry/edit.

If you want to provide db for analysis, follow instructions at bottom of my post.

INSERT SQL action can act on only one table at a time.