request a tip on how to diagram the Base and a Form (1 Viewer)

DreamerArgentino · May 19, 2018

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 · May 19, 2018

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 · May 19, 2018

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 · May 19, 2018

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 · May 19, 2018

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

Pat Hartman · May 19, 2018

The selected tasks table might need two additional columns:

AssignedDate, DueDate

Best Practice is to form your object names using ONLY upper/lower case letters, numbers, and the underscore. My preferred naming style is CamelCase. Others prefer the_underscore. I don't like having to use the shift key when I type. When you use CamelCase, you only have to use caps when you define the variable. After that, just type camelcase and Access will automatically capitalize it for you.

DreamerArgentino · May 20, 2018

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

Ok apologies for the transgression!

pbaldy · May 20, 2018

DreamerArgentino said:
Ok apologies for the transgression!

No worries, welcome to AWF!

DreamerArgentino · May 20, 2018

CJ_London said:
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 · May 20, 2018

I made one too as sample

DreamerArgentino · May 21, 2018

arnelgp said:
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.-

request a tip on how to diagram the Base and a Form (1 Viewer)

DreamerArgentino

New member

Attachments

DreamerArgentino

New member

Attachments

June7

AWF VIP

CJ_London

Super Moderator

pbaldy

Wino Moderator

Pat Hartman

Super Moderator

DreamerArgentino

New member

pbaldy

Wino Moderator

DreamerArgentino

New member

Attachments

arnelgp

..forever waiting... waiting for jellybean!

Attachments

DreamerArgentino

New member

Similar threads

Users who are viewing this thread