actually i've posted from the wrong thread and i apologize for that.
anyway, let me post my problem and it goes like this. we've successfully created drop down menus that is connected to our database. we have 5 fields to display, each field contains different data [(ex. first field contains - milk, soap, sardines, noodles and coffee),(second field contains - powdered milk, condensed milk, evap milk, spanish sardines, tomato sardines, laundry soap, bath soap, instant noodles, quick cook noodles, instant coffee and decafinated coffee)]. so its like when you choose milk on your first drop down, the second drop down should contain everything concerning milk, thus it should only show powdered milk, condensed milk and evap milk. Please help me... Thanks in advance.