Okay, bear with me on this one, I’m a relative newcomer to Access!
I’m using Access 2007 to create a database of jobs carried out by my company. As part of that we need to know which engineer has carried out each job. On my table “tblJobs” I have two fields, “Engineer” and “vehicle Reg.” The “Engineer” field looks up the list of engineers from a table called “tblEngineers” which lists the engineers and their vehicle registrations. My question is, how do I get Access to automatically fill in “Vehicle Reg” based on the “Engineer” selected? Any help would be greatly appreciated!
