L
Lynxboy252
Hi there,
I need help with combo boxes.
I'm currently designing a database to keep records of individual vehicles
operated by particular companies and the depot that they're allocated to.
For example. Bus 154 is operated by Big Bus Company and is allocated to
their depot in, lets say London.
I have a table with the operator information in, another table with depot
names in which are linked to the operator. So one operator can have many
depots. The vehicle info is kept in a vehicles table. I input the vehicle
information which is fine but what i want to do with my form is for each
vehicle I enter, I'd like to select an operator from a combo box. Then, in
the depot combo box, I want it to show me only the depots relating to the
operator I'd previously selected and not every depot I have in my depot table.
I do apologise for the poor explanation and I do hope it makes some sense.
This is driving me crazy and I anticipate it to be something very simple,
though have to admit i'm not terribly great with SQL etc.
Can someone advise me on how I go about doing this?
Thanks in anticipation.
Adam.
I need help with combo boxes.
I'm currently designing a database to keep records of individual vehicles
operated by particular companies and the depot that they're allocated to.
For example. Bus 154 is operated by Big Bus Company and is allocated to
their depot in, lets say London.
I have a table with the operator information in, another table with depot
names in which are linked to the operator. So one operator can have many
depots. The vehicle info is kept in a vehicles table. I input the vehicle
information which is fine but what i want to do with my form is for each
vehicle I enter, I'd like to select an operator from a combo box. Then, in
the depot combo box, I want it to show me only the depots relating to the
operator I'd previously selected and not every depot I have in my depot table.
I do apologise for the poor explanation and I do hope it makes some sense.
This is driving me crazy and I anticipate it to be something very simple,
though have to admit i'm not terribly great with SQL etc.
Can someone advise me on how I go about doing this?
Thanks in anticipation.
Adam.