ms access query

J

john

I have a unique situation;

I have a table tha is linked to several other tables & I want to be
able to insert in to an update query the following;

The name that I am searching for and then be able to enter the new
name in the update to field. I can write the other queries to update
the linked records, but I don't know how to enter the data manually in
the lookup fields.

This will be done on a regular basis so I need a solid way of doing it.
 
J

John W. Vinson

I have a unique situation;

I have a table tha is linked to several other tables & I want to be
able to insert in to an update query the following;

The name that I am searching for and then be able to enter the new
name in the update to field. I can write the other queries to update
the linked records, but I don't know how to enter the data manually in
the lookup fields.

This will be done on a regular basis so I need a solid way of doing it.
Click to expand...

If you're trying to copy names or other data from one table to another...
*you're missing the point of how relational databases work*.

Relational design uses the "Grandmother's Pantry Principle": "A place - ONE
place! - for everything, everything in its place". You should store the name
in a table of Names, and noplace else; in the second table you would store
only an ID linking to the names table (perhaps using a Combo Box on a form).
To see the name in conjunction with data from the second table use a combo box
which stores the ID but displays the name; for reports, use a Query joining
the two tables.

Note also that most developers dislike the "Lookup Field" feature in Access
(at any rate in tables); see
http://www.mvps.org/access/lookupfields.htm
for a critique.

John W. Vinson [MVP]
 
Top