How to autofill a field in Access based on data in another field.

By tony-oborne ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums