Many to Many Relationship
Hello All, I have a table with lists of tasks that we need to work on daily and another Schedule table that has all employees and their availability dates. The usual situation is that 1 employee can ...
Forum Discussion
Hi Ivan, I already have that as shown in the diagram it's called "Schedule" table, it has a many to one relationship to "Employees"
------------------------------
Karim Gawish
------------------------------
------------------------------
Karim Gawish
------------------------------
I am not quite understanding exactly what you are trying to achieve with the schedule table. What is that table doing for you? Why not just have the tasks and employees tables with a join table in the middle? That in essence would be your schedule table but the arrow to employees flipped the other way. I am not following the use case of that schedule table.
------------------------------
Ivan Weiss
------------------------------
------------------------------
Ivan Weiss
------------------------------