Trying to create an exam candidate booking form

Hi there,

I am trying to create a candidate booking form that pulls candidates from a candidate table and exam papers from an exam papers table to then be used to populate a candidate booking table and later tables for reading,writing, speaking and listening.

I have only got so far and am unsure of how to enable selecting of multiple candidates and pushing the selections for each paper type at the top to the input fields for each candidate selected with a tick on the left hand side of the table.

Once the input fields for each selected candidate are populated, I am hoping that Book Candidates can push the chosen versions to the respective models for each paper type (Listening, Reading, Speaking or Writing). Additionally, I would like to be able to also book all candidates at once once papers have been prepoulated but am happy if the Book Candidates link can be used for each candidate as a compromise.

Tables are:

  • Candidates
  • Candidate Booking
  • Listening
  • Reading
  • Speaking
  • Writing

Any suggestions would be greatly appreciated!

Here’s what I have so far!