Finding related fields in multiple Tables

J

johnwy

Forgive me but I am new to Access. I have three fields, job#, trans_id and
GL_Acct that I would like to query and then correct the GL_Acct. I will need
to change the GL_Acct in every table affected. Does anyone now how to find
which tables have the three common fields?
 
J

John W. Vinson

Forgive me but I am new to Access. I have three fields, job#, trans_id and
GL_Acct that I would like to query and then correct the GL_Acct. I will need
to change the GL_Acct in every table affected. Does anyone now how to find
which tables have the three common fields?
Click to expand...

Well... there's no way we can tell, because we don't see your database.

Are you storing this data redundantly, or is it a linking field? A basic
principle of relational database design is that you should store each piece of
information once, and once only. Is GL_Acct the Primary Key of one table? If
it occurs in other tables, do you have a Relationship linking it to the
accounts table? If so, you can set the Relationship's Properties to "Cascade
Updates"; any update done to the main table will be propagated to the related
tables.

If the GL_Acct is *not* involved in a relationship... maybe it should *not
exist* in the related tables.

What are your tables? What is each table's Primary Key? How are the tables
related?

John W. Vinson [MVP]
 
Top