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.

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.
--
Bob Larson
Access World Forums Super Moderator
____________________________________
If my post was helpful to you, please rate the post.


"Brian" wrote:

> 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.
>
>