I'm using DR3.2 and DNN4.8.4
have several questons:
1. i need dropdown field (like country field)in my registration form but i can't find it in types of field in DR3.2
2. i have 3 fields that depends on users response: sphere with profession. How can i show users only that professions that deals with the sphere that user selected? (i.e. user selected sphere: "music", and then registration form should show him "singer", "producer", "musiant")
i had created such fields: sphere and profession. i get data for this fields by sql query.
for sphere field:
select all value as QuestionOption from Sphere
select all value as QuestionOptionValue from Sphere
for profession field:
select profession as QuestioOption from Professions where SphereID=(Select Id from Sphere where valu='$(Sphere)')
select profession as QuestioOptionValue from Professions where SphereID=(Select Id from Sphere where valu='$(Sphere)')
SQL test is going good without errors. But when i try to test register form, profession field is blank 
what was my mistake? |