Need help setting up pages of questions - 400 variables to return a single 10-20 string?

[missusbee]

I am trying to figure out the best way to create a database and the more i find out the more questions I have!

I want to create a questionnaire front database for the teachers at school - why did I volunteer? But anyway. I need the functionality where I can go to open the questionnaire, go through a page per subject category and click each subject category that the student/students have done in a project, then click on the student/s which would then create a record per student listing all the subjects the y covered in the project. In also want on the first page to put in the date, and importantly, by hand a unique identifier so if I want to look at the class overall I can sort by this code and eliminate the duplicate records for each student.

The relationship would be for the student table and date table.

The subjects I would want all as look up tables - would I need to create one table per subject category, i.e. not just ENglish, but English lit and how can I put in a toggle which can be clicked on to then transfer that code to the record? There are up to 400 possible variables, and I want to create a record with the specified variables chosen through clicking n the toggles.

Any ideas appreciated please - I have a day to create it

[CRIMEDOG]

I am not understanding what exactly needs to happen. - Have you created a mock up? (If it were working this is what I want it to look like...)
Include a couple of subjects
Then upload
Then perhaps we can add the function you want

[FDibbins]

Hi and welcome to the forum

" - why did I volunteer?" lol, Im thinking the same thing myself right now

Have you made a start on this yet? It would be helpful to see some sample data (of all types), as well as some examples of your expected outcome (manually entered if necessary)

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.