Ok my basic setup is that I have a Projects table. Each Record is a different project. The projects table includes an Employees field. How would I go about setting it up so that multiple employees can be assigned to a project instead of just one.
Right now it is set up so that you can select one employee from the Employees table.
I would also like to set it up in the future so that I can generate a form that tells me what projects each employee is working on.
Any help would be greatly appreciated! Thanks!
Right now it is set up so that you can select one employee from the Employees table.
I would also like to set it up in the future so that I can generate a form that tells me what projects each employee is working on.
Any help would be greatly appreciated! Thanks!