Multi-select check boxes

[Kayleigh]

Hi,
I have a Google Form which is used quite extensively by staff for data input. The information is transferred to our database.
I am looking to replicate the Google Forms design in the database to limit admin workload.
The form in database is based on simple table recording staff name, date, lesson number, pupil name and points achieved.
Please share your thoughts on how this can be implemented.
Thank you

 

[arnelgp]

session number and date should be in MasterTable
the other fields goes to Another Table.

the "Another Table" is made subform (datasheet view) to
"single form" MasterTable.


Edit: on second thought all can go to a single table!

 

[Kayleigh]

Would a continuous form work?

 

[arnelgp]

see this sample

 

[Kayleigh]

Thanks @arnelgp !
I've implemented but it is not displaying in Form view. Would you be able to look at the modified input form please?

 

[arnelgp]

bacause you set Data Entry property to Yes, it should be No.

 

[Kayleigh]

Yes but I would like to add new records in this form - not view previous?

 

[arnelgp]

ok, put back Data Entry to Yes, but Allow Additions should also be set to Yes.

 

[Kayleigh]

Just to say thanks so much for your solution above. I have developed it further to achieve a functional solution.

One question about the design - having a session number and date repeated for each record seems to be denormalising the data?