Creating update query to update non primary key.

[george.greiner]

Hi.

I am trying to create an update query that will update a table based
on a "key" to what that key represents. In essence I have two
tables...one with the key in it and one with the key and the meaning
behind that key in it and need to put that data into the field in the
current table.

In this case the key is [BRTDATA]![BLDGCD] and I need it to update
based on that key to [Buildcod]![DESC].

The key in the second table is [Buildcod]![BLDG CODE] which has the
values that are in [BRTDATA]![BLDGCD].

So I need [Buildcod]![DESC] to update [BRTDATA]![BLDGCD] based on the
values. If need be creating another column is fine as I had to do
that with other update queries but this one has me a bit vexxed and
that could be called [BRTDATA]![DESC].

All the data are text values are come out of a comma delmitted text
file.

Any help would be great and thank you in advance.

 

[Jerry Whittle]

If I understand the problem correctly, you don't need to update the table.
You just need to join the two table in a query when you want to see the
description.