Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best Practice: Same table structure 3 documents, 1 DBF ot 3
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Best Practice: Same table structure 3 documents, 1 DBF ot 3
Divers
Thread ID:
00769113
Message ID:
00769113
Vues:
54
Hi all

I have a requirement for a Journal Voucher, Debit Note and Credit Note data entry screens. The table structure from what I feel will be the same roughly: No., Dt., Dr. A/c., Cr. A/c. and Amount. Please correct me if I am wrong.

Q1. Should I have the same table and same screen for the 3, with an additional flag in the table that notes, for eg. 1-JV, 2-DrNote, 3-CrNote?

Q2. Should I have the same table and 3 diff. screens, with the addition flag as above internally populated?

Q3. Should I have 3 table and 3 screens?

Please advise.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform