Update Column

[access1]

Hello-



How can I add 'Graphic Design' from TableB to all empty TableA fields associated with Manager Name Lewis and Region US?

Example:

TableA

Manager Name	Budget	Region	Unit
Lewis	500	US
Lewis	1000	EU

TableB

Manager Name	Region	Unit
Lewis	US	Graphic Design

Thank you very much!

[June7]

Run an UPDATE query. Use the query designer to help build. Access Help has guidelines for updating a table with data from another table. Or Google the topic. This is basic Access functionality.

[access1]

Thanks for the reply June7. I have tried from Microsoft help and google the topic but still is not clear. Quite a newbie in Access.
Please let me know if someone knows the answer out there.

Thank you.

[orange]

Your table structures are questionable. You should review this article
http://forums.aspfree.com/attachment...2&d=1201055452

In relational database you would not normally have the tables you have described. Fields ( Manager, Region , Unit) are repeated in different tables. Manager Lewis has 2 records with different values. If these records are meant to show English and French (US/EU), then you should identify a language field.

You may wish to review the definition and importance of Primary key and the uniqueness of records in tables..
http://databases.about.com/cs/admini...primarykey.htm

What do TableA and tableB represent to you?

You may have tables such as tblRegions, tblUnits, tblManagers, tblBudgets

As June7 said - in very general terms - you would use an UPDATE query to update fields in a table from another table.
see http://www.techonthenet.com/sql/update.php