my data will contain something like the file I uploaded in this post. I don't have the real data because it's at the place where I'm working on it. I want the cascading list to be if I choose Diagnosis (A), then the risk Factor (A) will be in the next drop down instead of risk factor A-E.(btw there could be more than one risk factor for diagnosis A. ( ex. risk factor A.1, A.2 A.3).
I want to know how to create a cascade and create the database the right way for the data I have. Every time I try follow the steps of tutorial they never work. The data usually populates in one list, but not the others.