Ok I realise my last submission was waffle so in short here is what I need to do:
Populate a List Box lstManufacturers with the distinct values from a specified Column in a database table. The Column is called 'Car Manufacturers' and there are 4 distinct values in this column: Jaguar, Audi, BMW, Mercedes.
I then need to populate another List Box but this is only done after selecting one of the above values from the lstManufacturers it then displays the makes of the Cars from another DB Column 'Car Models' in this 2nd List Box lstModels. This 2nd List Box only displays the Car Models for the selected Manufacturer.
Any help greatly appreciated....