[Solved] Request a tip on how to diagram the Base and a Form
Posted: Sun May 20, 2018 4:38 am
Hello everybody!!
I request a tip on how to design the Base and A Form correctly
I'm learning Base, and I have the need to create a small database with a Form and then get some statistics.
The approach seems to be quite simple:
1-Tables:
TBL-Students (ID-Student, Name, Surname)
TBL-PossibleTasks (ID-Task, TaskName, Select)
TBL-SelectedTasks (ID-TaskSelected, ID-Student)
2-Loading Form: With the following fields (See image "FormDesign"):
ID-Student, Name, PossibleTask Names---> with their respective Selection Checkbox (Tasks01 to Tasks55) - You can choose 1 or more tasks)
-----> and here are my queries:
1-How do you advise me to design the tables? that is, where would the selections of the checkboxes store?
2-Regarding the Form: How can I do it with a continuous type, containing said checkboxes + the Name of the task?
I made a small test base, but I'm really stuck! Please help me!!
I hope you can give me some idea based on your experience.
Thank you very much for your patience and your help.
Greetings.
Dreamer.-
I request a tip on how to design the Base and A Form correctly
I'm learning Base, and I have the need to create a small database with a Form and then get some statistics.
The approach seems to be quite simple:
1-Tables:
TBL-Students (ID-Student, Name, Surname)
TBL-PossibleTasks (ID-Task, TaskName, Select)
TBL-SelectedTasks (ID-TaskSelected, ID-Student)
2-Loading Form: With the following fields (See image "FormDesign"):
ID-Student, Name, PossibleTask Names---> with their respective Selection Checkbox (Tasks01 to Tasks55) - You can choose 1 or more tasks)
-----> and here are my queries:
1-How do you advise me to design the tables? that is, where would the selections of the checkboxes store?
2-Regarding the Form: How can I do it with a continuous type, containing said checkboxes + the Name of the task?
I made a small test base, but I'm really stuck! Please help me!!
I hope you can give me some idea based on your experience.
Thank you very much for your patience and your help.
Greetings.
Dreamer.-