Hi,

I am currently working on a database to store a list of parts with descriptions and prices. These all sit in a "Parts" table. Unfortunately we get the part data from two seperate sources, one supplier gives us a db file where there are two seperate tables, one containing a part number and a description, the other having a part number and pricing. Because of this I am not able to create a relationship between the three tables, as all other parts are to be entered manually and will never appear in the other lists.

What I would like to do is to be able to take the two tables from the suppliers mdb file, copy it into my database as two static tables and run a macro that opens up my parts list, takes the first Part ID number, looks for it in the supplier names table, checks that the names are consistent (and updates it if not), then does the same with the pricing table. Where the Part ID does not exist in the suppliers tables, I want it to skip that particulr Part ID and move onto the next one.

Is any of this possible, or is there a better way of doing this?

Thanks,

Ryan