Somehow I have a short circuited my brain :( and need some guidance.
Employer table has employer name and id (etc.)
Plan table has employer id, date, work start, work ends (etc.) fields
How can the input be managed or shown in grid (sheet) like form in VFP which at least employer name and work start time?
Name Week Mo Tu We Th Fr Sa Su
-----------------------------------------------------
Emp 1 20 8:00 9:00 8:30 9:00 9:00 9:00 9:00
Emp 2 20 (start time)
Emp 3 20 .
Emp 4 20 .
.
.
Emp 1 21
Emp 2 21
Emp 3 21
Emp 4 21
.
.
Then there is a need for reports from Day1 to Day2 for employers. F.ex 7/1/2005 - 7/31/2005 -> the first day for the report is not the first day of the week.
Is there a need for more tables like Days table Mon D, Thu D, Wed D, Thu D, Fri D, Sat D, Sun D where are all days of the year? Or is this too tough to VFP and needs an ActiveX. If this is a case what would be the suitable AcxtiveX?
TIA
AT