Add one record to multiple tables, NEED HELP ASAP

[Brian]

What I am trying to accomplish might seem to be set up wrong but the reason I
set this table up this way is due to the security settings I must put in
place.

I have a database with about 6 tables in it. This database is set up to
track a whole manufacturing project with many different fields such as
suppliers, quality, Tooling, Bill of materials each one of these tables have
a identifier number that I picked in each one of the 73 part records.

What I want to do is when I create a new record with in one of the tables I
would give it a identifier, I want it to add that new record with that
identifier to each of the other tables. I would like this so I would not have
to go in to each table and creating the new record with the Identifier I
chose.

I understand that it would be nicer to have all this data in one table but I
have decided against this due to security purposes and also amount of
information.

Thanks for your help.

 

[boblarson]

I won't comment on the way you're doing this, but look into using Append
Queries in conjunction with a form to do what you want.