I'm looking for ideas or suggestions about how to implement this feature.
The concept is I have 2 dropdown select boxes, with data that is not directly related (in the sense that there is no identifiers or foreign keys or anything within the data itself) but that have a logical relationship (although some data may not correlate to anything).
The dropdowns are populated from a database via ASP.NET, and I need to be able to select a value in dd2 based on the user selection of dd1.
Example data set;
dd1 dd2 | relationship -----+------+--------------- A W | A -> X B X | B -> Z C Y | C -> Y D Z | E -> W E | F -> Z F |
My question is, is there a more efficient way of doing this?
How would you approach finding a solution to this problem?