Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scheduling work hours per employer
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Scheduling work hours per employer
Versions des environnements
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Divers
Thread ID:
01032268
Message ID:
01032268
Vues:
65
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform