How do i approach this problem?....
How do i create a system that allows me to select a product from the first data entry point, which in turns allows me to select a sub-product entry from a list that is specific to the initial selection?
I guess its some kind of cascade that i need, but i am unsure how to achieve it?
do i create a dropdown value list for all products, and separate lists for each set of sub-products? How do i tell the database to only show the relevant sub-product list?
thanks in advance