Hi,
I have a form based on a table. The table has records which contain manufacturers, the equipment type, and items.
For example, if this were a car dealership, the table might contain:
Field - Make, Model and Vin
Records 1 - 7 contain:
Ford, Mustang, Vin # 123456
Ford, Mustang, Vin # 123457
Ford, F150, Vin # 654321
Ford, F150, Vin #754321
Mercury, Sable, Vin # 555123
Mercury, Mountaineer, Vin # 333123
Mercury, Marauder, VIn # 999123
I would like three object on the form:
A browse table with the make, model and vin
a listbox containing a variable called vc_make, showing only:
Ford
Mercury
(each Make one time)
I would like another list box (variable called vc_model) showing only the models available for the chosen make in the above list box. If Ford is chosen, I want this to show in the 2nd list box:
Mustang
F150
and the records filtered in the browse, depending on which make and model are chosen.
If Mercury is chosen, I would like the 2nd list box to say:
Sable
Mountaineer
Maurader
I cannot get the the Make nor the Model to display only unique items. Make list box shows:
Ford
Ford
Ford
Ford
Mercury
Mercury
Mercury.
I am choosing compute records automatically from table, choosing the correct field, and checking "Display only unique keys."
Am I missing something? Am I doing something wrong?
Any help would be appreciated.
Thanks.
Jay Talbott
I have a form based on a table. The table has records which contain manufacturers, the equipment type, and items.
For example, if this were a car dealership, the table might contain:
Field - Make, Model and Vin
Records 1 - 7 contain:
Ford, Mustang, Vin # 123456
Ford, Mustang, Vin # 123457
Ford, F150, Vin # 654321
Ford, F150, Vin #754321
Mercury, Sable, Vin # 555123
Mercury, Mountaineer, Vin # 333123
Mercury, Marauder, VIn # 999123
I would like three object on the form:
A browse table with the make, model and vin
a listbox containing a variable called vc_make, showing only:
Ford
Mercury
(each Make one time)
I would like another list box (variable called vc_model) showing only the models available for the chosen make in the above list box. If Ford is chosen, I want this to show in the 2nd list box:
Mustang
F150
and the records filtered in the browse, depending on which make and model are chosen.
If Mercury is chosen, I would like the 2nd list box to say:
Sable
Mountaineer
Maurader
I cannot get the the Make nor the Model to display only unique items. Make list box shows:
Ford
Ford
Ford
Ford
Mercury
Mercury
Mercury.
I am choosing compute records automatically from table, choosing the correct field, and checking "Display only unique keys."
Am I missing something? Am I doing something wrong?
Any help would be appreciated.
Thanks.
Jay Talbott
Comment