One table that I use is about projects.
- One of the fields is a multiple select that allows me to select which employees are working on that project.
- Another field is a start date, and another field is an end date.
I would like to make a new table that links to the above-mentioned table that has an employee (one) as the first field with that project they are working on as another, and the individual start and end dates.
My end goal is to make to calendars:
- One of the projects
- Another of my employee’s schedule.
How can I do this?