Author: volcano84 | Posted on: 9/7/2010 1:40:40 PM | Views : 287

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 ...