I have got a little stuck and would appreciate some help please.
The app uses a form to submit new records:
It allows a user to select an employee and multiple tasks and should (when the tick is pressed) create new records for each. For example, if you select an employees and two tasks, it will create two new records.
The records are saved into a list ('Task Tracking') with the following columns:
Date of Task (Date and Time)
Employee (Lookup - references Id of employee from another list)
Supervisor (Lookup - references Id of supervisor from another list)
Task (Lookup - references Id of task from another list)
There is also a list ('Task') where the "Task" from 'Task Tracking' List is looked up.
'Task' List has the following columns:
ID: The ID number of the task
Field1: The name of the task
The code I have on the "OnSelect" is
Note: DataCardValue10 is a dropdown multiselect list of Tasks
It will store all of the records in the List, however EVERY record in the List has the same Task in the "Task" field. Whatever the last task selected by the user is is what is inserted into the collection Task field. For example, if you had "Wash Car, Polish Car, Detail Car" all selected, it would store "Detail Car" for the Task for all new records created.