Edit Button

  • Thread starter Thread starter Penny
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically enter values in fields in a table 1
Search 2 fields simultaneously 2
Select All Button...Select all items in a subform once clicked 1
VBA - retrieve data on last create named range from previous inserted named range 0
Seemingly Simple Radio Button VBA Code 2
Access Automatically Send a notification email once a record is added 0
Appending records to new table using field names as values 2
Linking First and Last Names 4

Back
Top