I have the following database, consisting of 3 tables: Job, JobPhase, Assigned (as seen in the following image)
I'm trying to create a page that will hold a table. The table will represent, for a particular employee (ID = D_ID), his/her corresponding Job Schedule sheet. This table will consists of the following columns:
Job ID
Description (from table 'Job')
Comments (from table 'Assigned')
7 columns representing days of the week, with the first column representing Today's date, the next column representing the next day...
-> The 7 columns for the dates will not come from the database itself (as opposed to the other columns). However, for each row, we have to check wether the s ...
Go to the complete details ...