I have 2 dropdowns type and courses type will be premium, free and courses for premium java, c++, and also for free also I have java , python like this . i need to display all the courses when in default and when type selected as premium it will only show that category courses. but java is in both category it displaying 2 times by default . In db they have mapped with thier unique type ids only. I tried with union but choice values and choice values length varies because of that. Can anyone help me ?
Discussion posts and replies are publicly visible
As per my understanding on what you said. You are having a table that contains the courses like this CourseId Course Type1 Java Premium
2 Java FreeSo from this table only you are going to get the courses and displaying them in drop-down right?You are trying union on courses that is choice labels and unable to use union on choice values that is courseId.If this is the case I have some doubts
1.Why you want to show all the courses in drop-down before selecting type?
2.What you want to store as type premium or free when no type is selected and you are selecting the course?
If no type is selected and if you want to store free then you can have the choice values {2} instead of {1,2} by using wherecontains and index.