t
he first form is called "Car "
single line "Automobile Make",
single line
"Model",
single line
"colour"
single line
"unique ID" (database driven)
Each Automobile has 5 wheels and tyres hence
2nd form is called "wheels"
Lookup Form "Car" for "unique ID"
Advanced display options shows
"Automobile Make"
single line" Wheel1,
single line" tyre 1,
single line"wheel2,
single line"tyre 2, etc etc
Form 3 is called "emissions"
Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile Make" single line" emissions"
single line"Exhaust type"
single line"CO%"
single line"Date tested"
How do I get to choose the "Automobile make" in the first form and then filter across for the other 2 forms to only show that Automobile (unique ID) records for forms 2 and 3.