Hello,
Well, I think I have fixed my first problem, but you may have answered my next question.
I re-worked my db like so...
I created an emp tbl that has the cols : id, fname, lname, avail, area.
I used datatype SET for avail [Mon-Sun]
I used datatype SET for area [Bake-Register]
ex.
Code:
+-------+--------------+-------------+--------------------------------------------+--------------------+
| empID | empFirstName | empLastName | empAvail | empArea |
+-------+--------------+-------------+--------------------------------------------+--------------------+
| 192 | Carly | Smith | Monday,Wednesday,Friday,Sunday | Bakery,Dine,Dish |
| 209 | Chris | Jones | Tuesday,Thursday,Sunday | Dish,Line,Register |
...but then you are correct in noting that an emp maybe not be avail all day. ex- school, other jobs, family.
I will implement you design idea and see how it works!
Thanks for your time and ideas!
-Justin