Populating sequentialcombo's or fields
I have a table consisting of three columns , is it possible to populate
the second box dependent on the values in the first box and the third
field dependent on the second selection.
The table is as below:
Make Model Points
DATSUN Other 148
DATSUN Patrol 152
DATSUN Sunny 136
DODGE All Models 200
EUNOS 30X 204
EUNOS 500 208
EUNOS 800 220
FERRARI Berlinetta 320
FIAT 128, 131, 132 180
I have created a unique list of makes , if the user selects Eunos , I
would like the second box to contain the three models and then ideally
the last box to contain the points.
Have tried combo boxes and data validation with no success.
Appreciate any hints/ideas,
Jeff
|