Hi All,
I don't really know how to call it but multi entry form came into mind. I'm trying to create a form that makes sense to our users and the form should look like the attached PDF. Some ideas on how to create the form should be great.
Thanks.
Hi All,
I don't really know how to call it but multi entry form came into mind. I'm trying to create a form that makes sense to our users and the form should look like the attached PDF. Some ideas on how to create the form should be great.
Thanks.
Build an 'entry' table that looks like your screen.
When the user clicks SAVE, run queries to parse the data into its normalized tables.
I'm new to creating forms. Would you be able to give me some steps on how to create the 'entry' table?
Do I need to create a Save button on the form?
Thanks.
To have the look you present, I think you are looking at a main form with 4 sub form controls, one for each week but I tend to see things as being more complex than they are sometimes! The only way I know that you can get detail sections side by side like that is to position sub controls next to each other. If correct, I would not go there if not absolutely necessary as it would be no small task to correlate everything. Consider Store, WeekNum and Day (SWD) as combos whereby the data entered into 4 Min and 4 Sup controls (each bound to their own field) in the detail section is tied to the combination of SWD for the record. You would not need a Save button if you were creating records or editing on the fly. Watch the use of reserved words when naming stuff. Min is a reserved word.