I have a database in which I have a projects and an employees table. I have a form that allows users to create a new project. I have a button on that new project form that says "Assign Employees" which opens another form. The Assign Employees form has two listboxes in which you can move members drawn from the employee table to the right and back to left to determine the work group desired to work on the new project being created in the new project form. I can't figure out how to make the selected employees, now in the right listbox, to display on my original form, and after the new project is saved, to save all the project info, including the assigned employees to the Projects table. I also would like users to be able to click the assign employees button again to be able to change their selection if they change their minds Please help!! I've attached my database.
Thanks so much!