I have a field entitled "PRODUCT_LIST" which was a list of product codes populated over the years of from all of our various products that we manufacture. This list is used in a number of databases that I've created.

I now have an ODBC link set up to our company MRP which gives me "STOCKCODE" as a field in my DB as a separate table.

The two tables contain virtually the same info but the data in STOCKCODE is live and therefore the one I now want to use in my database to help validate & reduce uncontrolled data etc etc etc



How to I associate the info in STOCKCODE to the info in PRODUCT_LIST, use STOCKCODE as my primary source for part numbers and then delete the PRODUCT_LIST table that exists in the DB.

Cheers