This may be a stupid question, or it may have been answered a million times... I've got two tables... one that has my equipment inventory, with the asset tag as the key, and the other is an equipment repair table, keyed to the repair record number. I want to be able to update the fields of EQUIP_MFG, EQUIP_DESC and the like that are in the inventory table in the repair table without having to retype everything each time. I was hoping to be able to just type the asset tag in the field on the repair table and the rest of the fields fill in from the inventory table, so all i have to add is the extra fields on the inventory table that don't match. Is this even possible? Thanks for whatever help you can provide!!! I really appreciate it!