yesterdays
MIS
Hi
OK I want to get three list menu/droplist menus to work with each other and report all the information out to a text file or to something.
Here is the setup
An easy example of my database:- I have the droplist which is car manufacturers (ford, VW, etc...) The user clicks on one of these say ford. This fills a second droplist with all the ford cars, the user chooses escort. This opens a third droplist with steering wheel, gearstick etc.. They click on Steering wheel and the information is sent to a text file. I mean all the information so it would be FORD, ESCORT, STEERING WHEEL, not just STEERING WHEEL.
At the moment I have got the first droplist working it picks the data from the database and displays it.
1)--What do I do so that when a user clicks on ford it selects all the ford cars from the database and displays them in the next droplist.
2)-- how once the user has selected the correct data do I send it to a textfile or to a checkout basket which includes all the information not just STEERING WHEEL
Please help I'm stuck I have managed to work out how to get the data to the first droplist but I really need help with it.
OK I want to get three list menu/droplist menus to work with each other and report all the information out to a text file or to something.
Here is the setup
An easy example of my database:- I have the droplist which is car manufacturers (ford, VW, etc...) The user clicks on one of these say ford. This fills a second droplist with all the ford cars, the user chooses escort. This opens a third droplist with steering wheel, gearstick etc.. They click on Steering wheel and the information is sent to a text file. I mean all the information so it would be FORD, ESCORT, STEERING WHEEL, not just STEERING WHEEL.
At the moment I have got the first droplist working it picks the data from the database and displays it.
1)--What do I do so that when a user clicks on ford it selects all the ford cars from the database and displays them in the next droplist.
2)-- how once the user has selected the correct data do I send it to a textfile or to a checkout basket which includes all the information not just STEERING WHEEL
Please help I'm stuck I have managed to work out how to get the data to the first droplist but I really need help with it.