I guess my biggest question is, how can I get a Chemical Name associated with the appropriate NameID, on all of my old chemical name records? For example, in the old database, I would have a record as such: ChemicalID=3330 (PK, Autonumber), Chemical=Acetone, Company=Fisher, Lot#=ABC123, Received Date, Expiration Date, Room Number. But now in my new database I would have a Chemical (housed in the tblChemicalInfo), i.e. Acetone, Catalog #=1234AB, Company=Fisher, WITH Acetone and Fisher being housed as Numbers (FK's) from tblChemicalName, NameID(PK) and tblCompany, CompanyID(PK). The old record needs to have Acetone changed to 3 (the new NameID), and Company changed to 100 (the new CompanyID), in order for me to store that record. Can I assign these new ID numbers automatically somehow? Or is changing them all by hand (for 1200 records, ) my only option? Would running an update query to search for all records with Acetone as the name, and have an added column that would house the updated NameID?