add row number to a Subform
Posted: Tue Jul 18, 2017 12:15 pm
Hi. I would like to ask the user some questions 1 to 10 in a subform.
Row: Question: . Answer:
1. | (Display SQL= {Select Question From Questions WHERE Question_nr = 1} ) [________________]
how do I use a row number in my SQL display object?
like:
Row: Question: . Answer:
1. | (Display SQL= {Select Question From Questions WHERE Question_nr = 1} ) [________________]
how do I use a row number in my SQL display object?
like:
Select Question From Questions WHERE Question_nr = #subformROWnumber#