Update multiple fields in a table

  • Thread starter Thread starter Randal
  • Start date Start date
R

Randal

I have a drop down list that I use to add a name from Table1 to Table2.
Once I select the name, I would like the phone number from Table1 to
automatically populate the phone number field in Table2. Is there a way to
do this?
 
You are duplicating the data in two tables. This is not recommended and is
not part of normalized database design. If you want to relate the items,
simply pull the "customer number" or "key" from table1 and store that in
table 2. Then, you can display all the relateed data when you pull up the
table2 record in a form, query, or report.

Using your method, what would happen if the phone number changed? You'd end
up with quite a mess.

Rick B
 
That makes sense. But, if I do this with several tables, then the form has
to run off of a query that is not updatable. How do you get around that?
 
You'd have to give us a specific example of what you are doing. You would
maintain the customer name and address in one place, then use that data in
your invoice form, or your transaction form, etc. This is classic
relational database design.

Look at the Northwinds database and see how it handles customer data,
invoice records, products, categories, etc.

Post a specific issue if you have troubel with a non-updatable query.

Rick b
 
Back
Top