add row number to a Subform

add row number to a Subform

Postby willemgouws » Tue Jul 18, 2017 7:45 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:
Select Question From Questions WHERE Question_nr = #subformROWnumber#


subfrom.png
subfrom.png (14.48 KiB) Viewed 89 times

Question sql.png
Question sql.png (26.64 KiB) Viewed 89 times
willemgouws
 
Posts: 1
Joined: Mon Jul 17, 2017 4:20 pm

Return to General



cron