I created these two tables (Table1 and Table2) and realized that I have redundant fields in Table2. I have entered frame numbers and frame costs in Table2 when the corresponding ID from Table1 (which contains the frame numbers and frame costs that are identified with the ID) can be used instead. I want the SQL (or query) to look at the FrameNo field in Table2 and find the correct ID from the records in Table1 that has the same FrameNo field value then enter in that ID number to my newly created field in Table2. The field that I am updating is of Long Integer type, not Autonumber.
Thanks in advance.