Hello,
I have some experience with Access, but only using the GUI - I cannot code the SQL myself.
With that said, here is what I am trying to build a form where the choices for one field are dependant on the previous field. For example, say I have colours available based on a car model:
Cars: SuperCar
DuperCar
SuperCar's available colours: Yellow
Red
Blue
DuperCar's available colours: Yellow
Green
Purple
So when I have a form, I want the two fields to be:
Car:
Colour:
But the options available in Colour depend on the Car that is chosen.
Cheers,
Shaun