I have an employee table (id, fname, lname etc.) and a skills table (id, skill_name). They are linked by way of a junction table emp_skillz (id, emp_id, skill_id).
I have a radio button group in a form that renders for all the skills in the skills table.
I'm using a JS query to create a data array (from the selected buttons in the radio button group) to feed to a Bulk Upsert with Primary Key (GUI).
When I access a employee record that hasn't had any skills assigned to it, I select a couple of buttons and press "Submit", I get the following error.
Primary key id is not unique in the supplied array. The following keys were duplicated: null -- (2 dupes)
All thoughts welcome.