onClick command to insert data from one dataset to another

Hi Louval:

OK - I think you need to consider your data models in the context of your page requirements.
You seem to want to set up a many to many relationship between Candidates and Subscribed to Courses.

Many Candidates able to choose many Subscribed classes.

This will typically require three data collections

  1. Candidates
  2. Subscriptions
  3. Joining Table mapping Candidate to Subscription

So the page will essentially have a repeater showing a cards each representing the Candidate. On the card the drop down will show all available subscriptions from the subscriptions data collection
Also on the card will be another list (repeater) containing all of the Subscriptions from the joining table where the record contains the Candidates id.
When a drop down item is selected the id for the item from the Subscription table (this would be the Drop down item value) and the id for the Candidate on the card are combined into a new record in the join table.
After the join table is updated the Subscriptions list gets updated.
You could do a reverse where the list of subscriptions has a delete option that allows you to unsubscribe.

I think this is what you are trying to accomplish. I will try to knock together a quick example for this if you concur with this summary to show you how it is done.

Steve