When I select multiple list items on a check box list (EMPLOYEE NAME) I want to be able to view each item on a separate line/in a separate view record.
Because each 'EMPLOYEE' selected from the list went to the same 'TRAINING SESSION' each one has in common all the other details entered in the fields of that form.
So, where I can now view this:
EMPLOYEE DATE ST TIME ED TIME SESSION LOCATION NOTES
Name 1, 1/1/11 11:00 12:00 Safety conf rm misc notes
Name 2,
Name 3,
Name 4,
ETC.
I also want to view like this:
EMPLOYEE DATE ST TIME ED TIME SESSION LOCATION NOTES
Name 1 1/1/11 11:00 12:00 Safety conf rm misc notes
Name 2 1/1/11 11:00 12:00 Safety conf rm misc notes
Name 3 1/1/11 11:00 12:00 Safety conf rm misc notes
Name 4 1/1/11 11:00 12:00 Safety conf rm misc notes
etc
That way, I will be able to sort by EMPLOYEE and view all the training an individual employee has completed...
My form,
Add Training Session, has the following field types:
1. Checkbox Multi Select Lookup field: EMPLOYEE NAME