Matt,
If I'm understanding you right, you're essentially trying to merge your lut
table into your original table. The way I would do this is to add two new
columns to my first table called 'ComF7_lut' and 'ComF7_lut'. Then I would
do an SQL merge between my two tables based on the lookup code and view it
in a new browser (so that you will have one new table with all of the
columns from both tables including the two new '_lut' columns). Finally, I
would use the Update Column command and populate the '_lut' fields with
their corresponding descriptive column. This will autmatically update your
original table. Hope this helps!
Andrew MacDougall
[EMAIL PROTECTED] on 06/28/2000 02:23:59 PM
To: [EMAIL PROTECTED] @ INTERNET
cc:
Subject: MI An easy problem to sort?
Ok.
I think this might be an easy problem to sort out.
I have 2 tables.
One table contains objects with coding i.e. ComF7, ComF8.....
One code for each object.
The second one is a look up table with 2 columns.
ComF7 represents swimming pool
ComF8 represents Picnic area.
What I need to do is to update a column in the first table with
The descriptive reference of the second table (LUT)
So the end result will be having the code and the description in the first
table.
I hope someone has a quick solution cos it's driving me crazy.
TIA
Matt
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
