change the name address only once

[Guest]

How do I set up the access program to change the name address only once when
it is used on several different records and tables?

 

[Rick B]

This sounds like a one-to-many relationship. You should store the "customer
number" or "person number" in your main table. In a separate related table,
you store one record for each person including their number, the name,
address, etc. Then you can fix the person table without the need to change
your detail table.


TblDetail
CustNumber (related to TblCustomers)
Date
etc.

TblCustomers
CustNumber
CustLastName
CustFirstName
CustAddress1
CustAddress2
CustCity
CustState
CustZIP
CustPhone
etc.

 

[John Vinson]

How do I set up the access program to change the name address only once when
it is used on several different records and tables?

If you have the name and address stored in multiple tables, you've
made a mistake in your initial table design. Relational tables use the
"Grandmother's Pantry Principle": "A place - ONE place! - for
everything, everything in its place".

Store the name and address, *once*, and then use Queries to link to
the stored information (using a PersonID field for example).


John W. Vinson[MVP]