anyone know how to make a query work to update one table with data from another table where two fields matchs? when someone else designed the db they just created a flat file. I had to restructure the data. - they didn't have a serverno field (to uniquely identify host/servernames). I extracted the data into one table (list of servernames with a serverno) and then extracted the other data (IP's) into a another table. The first table generated the serverno field (autonumber) and I have to get it into the second table for the join/link.

so i started with
old table:
mac1 starwars 132.35.45.4
mac2 castle 135.45.4.3
etc.
(this didn't allow multiple ips - yea i know what were they thinking)

so i broke it to two tables
table 1
mac1 starwars (serverno.1)
mac2 castle (serverno.2)

table 2
serverno? 132.35.45.4 mac1 starwars
serverno? 135.45.4.3 mac2 castle

I left the machine name (mac1) and hostname(starwars) in the second table until I can extract the appropriate serverno and normalize the data.

thankx.

see if this (http://www.access-programmers.co.uk/forums/showthread.php?t=79619) will help. - w

thankx. I got my update to work finally :)