Add records to 2 tables simultaneously

[Lois]

I have two tables in the same database. The first is used
by another department, the second is for my use-the tables
are similar. When the other department adds a record to
their table, I would like it to be added to my table
automatically. Is there a way to join the tables so that
this happens?
Thanks for your help-

 

[John Vinson]

I have two tables in the same database. The first is used
by another department, the second is for my use-the tables
are similar. When the other department adds a record to
their table, I would like it to be added to my table
automatically. Is there a way to join the tables so that
this happens?

No.

And it's not necessary, unless you have a very strange set of
requirements. Storing the same data redundantly is what relational
databases are designed to PREVENT!

Let the other department store the data; your table should contain
only a field linked to that table's primary key and whatever other
fields you need for your own use. You can retrieve the data from the
other table in a Query.