C
Coleen
I have a simple database that has 6 tables: County, Emission Tests,
Registered Vehicles, Test Vehicles, Vehicle Type, and Technicians.
The "Main" table is the Test Vehicle table. It is joined to all the rest by
ID's. All my Id's are populating correctly into this main table from a form
for data entry. The table link between Test Vehicles and Emission Tests is
on Vehicle ID (Primary in the Test Vehicle table) and Emission_ID (Foreign
key to the Emission Test table) I have it set as a look-up (maybe I
shouldn't?)
The problem is that the subform (Emissions) doesn't get populated by the
Vehicle ID and the Test Vehicle table isn't getting populated by the
Emissions ID. I DO have the subform linked with the Child/Master fields in
the Subform, and can see that after the Vehicle ID (Autonumber) is populated
in the main form it is shown to populate correctly in the subform using
=[Forms]![ENGINE SWAP DATA ENTRY FORM]![Vehicle_ID]
But the tables are not getting populated! ARGH! Can someone please tell me
what I am doing wrong?
TIA,
Coleen
Registered Vehicles, Test Vehicles, Vehicle Type, and Technicians.
The "Main" table is the Test Vehicle table. It is joined to all the rest by
ID's. All my Id's are populating correctly into this main table from a form
for data entry. The table link between Test Vehicles and Emission Tests is
on Vehicle ID (Primary in the Test Vehicle table) and Emission_ID (Foreign
key to the Emission Test table) I have it set as a look-up (maybe I
shouldn't?)
The problem is that the subform (Emissions) doesn't get populated by the
Vehicle ID and the Test Vehicle table isn't getting populated by the
Emissions ID. I DO have the subform linked with the Child/Master fields in
the Subform, and can see that after the Vehicle ID (Autonumber) is populated
in the main form it is shown to populate correctly in the subform using
=[Forms]![ENGINE SWAP DATA ENTRY FORM]![Vehicle_ID]
But the tables are not getting populated! ARGH! Can someone please tell me
what I am doing wrong?
TIA,
Coleen