request a tip on how to diagram the Base and a Form

[DreamerArgentino]

Hello everybody!!

I request a tip on how to diagram the Base and A Form

I'm learning access, 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 (Task-ID, TaskName)
TBL-SelectedTasks (ID-Task Selected, ID-Student, ID-Task01, ID-Task02 .... to 55)

2-Loading form: with the following fields (See image "diseñoformulario"):

Student ID, Name, Name and Possible Task 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 draw the tables? that is, where would the selections of the checkboxes turn?

2-Regarding the form: How can I do it with a continuous type containing said checkbox + the name of the task?

I hope you can give me some idea based on your experience.
Thank you very much for your patience and your help.
Greetings.
Dreamer.-

 

[DreamerArgentino]

Hello everybody!!

I request a tip on how to diagram the Base and A Form

I'm learning access, 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 (Task-ID, TaskName)
TBL-SelectedTasks (ID-Task Selected, ID-Student, ID-Task01, ID-Task02 .... to 55)

2-Loading form: with the following fields (See image "diseñoformulario"):

Student ID, Name, Name and Possible Task 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 draw the tables? that is, where would the selections of the checkboxes turn?

2-Regarding the form: How can I do it with a continuous type containing said checkbox + the name of the task?

I hope you can give me some idea based on your experience.
Thank you very much for your patience and your help.
Greetings.
Dreamer.-

 

[June7]

Consider a form/subform arrangement. Main form bound to tblStudents and a subform bound to tblSelectTasks. Enter records for each student/task combination. This means a combobox to select task. You only create records where a student needs to be associated with a task.

 

[CJ_London]

your TBL-SelectedTasks is incorrect

it should just be
ID-Task Selected, ID-Student

then in your subform, ID-Tast Selected would be a combo using tasks as a rowsource

No need for a checkbox - just selecting the task indicates it has been selected

 

[pbaldy]

Duplicate threads merged since both had replies. Please don't post the same question twice.

 

[DreamerArgentino]

Duplicate threads merged since both had replies. Please don't post the same question twice.

Ok apologies for the transgression!

 

[pbaldy]

Ok apologies for the transgression!

No worries, welcome to AWF!

 

[DreamerArgentino]

your TBL-SelectedTasks is incorrect

it should just be
ID-Task Selected, ID-Student

then in your subform, ID-Tast Selected would be a combo using tasks as a rowsource

No need for a checkbox - just selecting the task indicates it has been selected

I made a small test base (attached here), but I'm really stuck!! Please help me!!! :banghead:

-I do not know how to generate the Form with the respective Checkboxes ...
-I do not know if I designed the tables and the relationships well ...

The idea is that the Form is similar to the attached image "FormDesign.jpg"


Thank you very much for your help!
Dreamer.-

 

[arnelgp]

I made one too as sample

 

[DreamerArgentino]

I made one too as sample

wow!! Awesome! It's not exactly what I had in mind, but it's a great help to me!!!
Thank you very much for your help and for taking the time!
Now I must sit down to analyze it and see how I carry out what I need!

I send you a big hug!
Greetings.
Dreamer.-