wvantongeren Posted March 7, 2016 Report Share Posted March 7, 2016 I´m making safety checklists for my end users (colleagues) 3 tables: 1 = Header table (Always the same: Name, Date etcetera) no problem there; 2 = Contant table (Variable questions) autonumum and normal numberd also no problem there; 3 = Footer table (Always the same questions) no problem there. The problem: 1 Submissionform My problem is to get all the queastions from table 2 in a submissionform. I do not understand how i get a variable number of questions in to my submissionform. See also: http://hemubo.weebly.com/Checklist_colleagues.html Thanks. Quote Link to comment Share on other sites More sharing options...
0 svitlanataran Posted March 9, 2016 Report Share Posted March 9, 2016 Hi, If I understand correctly, you use table2 as a data source for a submission form. I can recommend you to use Single Record Update Form if you would like to update one record. It is convenient if you'd like to see already submitted data and be able to update information, like in user profile. Find more information here But if you want to create an interface where the user will be able to update more than one record it is better to use a report DataPage and make the fields editable in the details page. Quote Link to comment Share on other sites More sharing options...
Question
wvantongeren
I´m making safety checklists for my end users (colleagues)
3 tables:
1 = Header table (Always the same: Name, Date etcetera) no problem there;
2 = Contant table (Variable questions) autonumum and normal numberd also no problem there;
3 = Footer table (Always the same questions) no problem there.
The problem:
1 Submissionform
My problem is to get all the queastions from table 2 in a submissionform.
I do not understand how i get a variable number of questions in to my submissionform.
See also: http://hemubo.weebly.com/Checklist_colleagues.html
Thanks.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.