Edit Button

P

Penny

Is there a way to have an edit button that would do the
following:
Go to a field name in multiple tables and edit that field.

For example: I have a field name named [Customer Name]
which has customer names in that field. This same field
name may be in multiple tables. Sometimes we don't have
the full legal name until after the fact. I would like to
be able to hit a button and I would be able to edit that
customer name and it would flow to all the tables. Is this
possible?

Thanks in advance
 
D

Douglas J. Steele

Sorry, but there's something wrong with your design if you have such a need.

Data should not be stored redundantly. Any table that needs the Customer
Name should really only contain the CustomerID (or whatever the primary key
is for your Customer table). Customer Name should only exist in the Customer
table. If you want it in conjunction with other tables, you join the tables
together in a query, and use the query, rather than the table.
 
Top