How to update a table?

[Guest]

Hi, all,
I have a problem while creating a Access databse. In this db, there is an
"Employee" table linked to other Access database. In this db, I also have
table "Team A Member" and table "Team B Member" generated by make-table query
against "Employee" table. My question is once "Employee" table updated, how
can table "Team A Member" and table "Team B Member" be updated automatically?

Thanks a lot in advance for any response.

 

[Nikos Yannacopoulos]

Frank,

It is generally wrong from a design standpoint to have multiple tables
with similar structure; the correct approach is to have one table with
an extra field to differentiate whatever the different tables do, in
your case Team A from B.

That said, if you can create those tables through a make-table query,
then I suppose you somehow filter table Employee to separate the A's
from the B's, so you are effectively duplicating data in separate
tables. This is not good practice. What you should do is delete the two
team tables, and use two queries instead, just like your make-table
queries, only changed to plain Select ones. This way you avoid
duplication, and your data is readily available at all times, without
the need to "update".

HTH,
Nikos

 

[Guest]

Thanks a lot. Your idea is simple and right on target. It is helpful.

 

[Nikos Yannacopoulos]

Welcome!

Thanks a lot. Your idea is simple and right on target. It is helpful.

: