Compare two tables in ACCESS and then populate vacant columns
Posted on 2009-05-13
I have a data base which has a table that will be continually updated. It will be updated with information regarding images.
Presently there is a table with all the data needed to populate the other table.
I'm wondering how to go through Table 1 and when it hits a record, it looks at for instance the image name and then go and search Table 2. If it sees the same image name, the query/script will then populate the remaining columns in Table 1 with the information from Table 2.
The Tables would be structured the same way, but they might not be in the future so perhaps the query/script can look at the column title and compare and update and/or the query can be run one column at a time with the user selecting the columns to compare and populate based on the key variable "image title" in this case.
Thank you in advance.