Hello - I need to track vehicle data in the following way: I have a driver, technology type (Backing sensors, adaptive cruise control, etc) and a vehicle number. As such I created three separate tables. The common denominator is the driver table in which I have a DriverID as my autonumber and have used the "Relationships" window to relate all three tables.

In my novice Access mind, I thought that one form could be used for data entry that will feed all three tables since they are related - or at least this is my thought process. However, when I add all controls needed from each table into the form and I go to view the form is it completely blank. I don't understand. Any help will be appreciated. Thank you.

Jose

---

Reply from Alex Hedley:

Create a Query with all the Tables joined.
Now click on the Query then click on the Form and it'll create a Form for you.
Or create a blank form and set the Record Source to your Query, now drag on your fields.