Hello,
I have a form with two listboxes, one which holds the names of positions and another that holds courses. Each of these is based on a parent table. I have a PositionCoursestbl which stores what courses are required for each position.
In my form, the user selects at least one position to edit and one course required for it. My issue is this: When I select at least one position and more than one course requirement, the table only gets updated with one record - the position and the last course selected. Ex. I select Accountant for the position and Course 1 and Course 2, the data stored in the table is Accountant and Course 2.
How can I have it so all the courses get updated? And how can i do this is more than one Position is selected (Multiple selections from both list boxes)?
Any help would be appreciated
Thanks,
David
I have a form with two listboxes, one which holds the names of positions and another that holds courses. Each of these is based on a parent table. I have a PositionCoursestbl which stores what courses are required for each position.
In my form, the user selects at least one position to edit and one course required for it. My issue is this: When I select at least one position and more than one course requirement, the table only gets updated with one record - the position and the last course selected. Ex. I select Accountant for the position and Course 1 and Course 2, the data stored in the table is Accountant and Course 2.
How can I have it so all the courses get updated? And how can i do this is more than one Position is selected (Multiple selections from both list boxes)?
Any help would be appreciated
Thanks,
David
