So this has to be simple but has driven me crazy all morning.  I have a form with 5 panels.  Each panel have 4 or 5 questions.  When I set the start and end question in the panel setup I assume the panel (section) would record the start and end sort order of the questions. 

My problem is that when I go through all the SPs and trace the SQL I don't see a procedure that pulls a start and end question.  All I see is this

exec dbo.DynamicForms_GetDynamicQuestionsByModuleIDForPanel @ModuleID=446,@StartSortOrder=1,@EndSortOrder=12

I can't figure out where in the database to get the @StartSortOrder and @EndSortOrder values.  Is there a SectionQuestionId Field I am missing or a start and end sort in the Dynamic_Questions table.

I just don't see it.

Pete

Hi Pete - I believe that it checks the specific DynamicQuestionID from the database for the starting question and ending question. So... When it passes these variables it is gathering them from the questionID's and then checking against the DynamicForms_DynamicQuestion table.

Thanks!

-Chad

Are the start and end QuestionIds stored in OptionType and OptionType2 fields?

Hi Peter - That is probably the case I believe yes. I would compare those fields I guess against the DynamicForms_Questions table and then you can also reference the SortOrder column.

Thanks,

Chad