More Than One Combox Issue
Posted on 2008-10-06
When I try to use more than one combox I have the following issue. Combox 3 when re-queried based on combox 2 results is displaying the results based on that entire column, so if you have duplicates in the column it will show the duplicates. What I want to happen is for it to re-query combo 1, then combo 2, and based on those results give me combo 3. This way it will prevent duplicates from showing. For example, lets say you have combo 1 (Ram Type), combo 2 (Ram Size), and combo 3 (Ram Speed). Now in the table you have the following columns Ram Type, Ram Size, Ram Speed. Now for the data Ram Type = Desktop, Ram Size = 256MB, and Ram Speed = PC2100. Now, lets say we add to the table this row Ram Type = Laptop, Ram Size = 256MB, and Ram Speed = PC3200. When I go to my comboxes and select Ram Type as Desktop, Ram Size as 256MB, when I view ram speed it will show both PC2100 and PC3200 even though only on exist for Desktop which is the PC2100. Any ideas how to fix this?