Hello!
I'm working in Access 2007 and I have a problem now. So, I created 3 tables:
a) cars
- ID_car
- ID_model of car
- ID_brand of car
b) models of cars
- ID_model of car
- ID_brand of car
c) brands of cars
- ID_brand of car
and I want to create form which will be able to synchronize brand and model of car. I mean, if I chose one brand of car (e.g. Renault), I can choose just the models belonging to this brand (e.g. Megane).
Is anybody who could help me in this case?
I'm working in Access 2007 and I have a problem now. So, I created 3 tables:
a) cars
- ID_car
- ID_model of car
- ID_brand of car
b) models of cars
- ID_model of car
- ID_brand of car
c) brands of cars
- ID_brand of car
and I want to create form which will be able to synchronize brand and model of car. I mean, if I chose one brand of car (e.g. Renault), I can choose just the models belonging to this brand (e.g. Megane).
Is anybody who could help me in this case?