Access 2003, Windows XP sp2 Problem: tblJob has a "Cost Center" field. tblInvoice has a "Charge To" field. I want the tblInvoice field "Charge To" to automatically populate with the information in the "Cost Center" field in the tblJob. These tables are related by a mutual primary key but neither of these fields are related and neither field is a primary field. Is there an easy way to make the tblInvoice "Charge To" field populate automatically with the information in the corresponding record entered in the tblJob, "Cost Center" field? I don't think the update query is what I am looking for nor is lookup as I need the record directly associated with both tables by Job#(primary key). I am hoping this is easy but I can't find an answer. Thanks for any assistance.