Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scheduling work hours per employer
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Scheduling work hours per employer
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01032268
Message ID:
01032268
Views:
64
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
Next
Reply
Map
View

Click here to load this message in the networking platform