Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Designing A Variable Status Report
Message
De
28/03/2000 12:54:30
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00351422
Message ID:
00351466
Vues:
24
I think I would work on the data model, then the input form, then the report. It sounds to me like the table could use some normalization. How about:

*** Main table

pkAction (primary key)
fkManager (foreign key to Manager table)
fkStatus (foreign key to status table)
start
ssp

*** Manager
pkManager (primary key)
ManagerName

*** Status
pkStatus (primary key)
Status

Now for the input form, you have all three tables in the Dataenvironment and use comboboxes to select a manager and a status. You use text boxes for the other stuff.

For the report, you use a SQL statement:

SELECT maintable.*,manager.managername,status.status FROM maintable,manager,status WHERE maintable.fkmanager=manager.pkmanager AND
maintable.fkstatus = status.pkstatus


>I have a table that consist of a status field that can have three or more variables such as working, planning, or complete.
>
>My plan is to develop a form for the user so he or she can input working or planning or complete. This input is passed to the report program for processing. These reports will look like this base on form input by user.
>
>manager status start ssp
>Dean working 08/10/99 99-521
>Dean working 08/02/99 99-528
>
>------------------------------------------
>Manager Status Start Ssp
>Hutch complete 09/01/98 98-520
>Hutch complete 08/15/98 98-023
>
>-------------------------------------------
>Manager Status Start Ssp
>Johnson Planning 07/15/98 99-529
>Johnson Planning 06/20/99 99-201
>
>
>1. Should i develop report first and develop user input
>form second?
>
>2. My input form will have these fields.
>
> TxtStatus - Text box containing working or complete or planning.
>
> CmdRunReport - button use to fire the form.
>
>**** Could I get some help on this???????? Have a nice day.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform