Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The right way
Message
De
24/09/2009 15:06:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
The right way
Divers
Thread ID:
01426003
Message ID:
01426003
Vues:
213
what's the right table structures for one-to-many forms?

eg. for invoicing, I use:

invoice.dbf
---------------
inv_no
inv_date
cust_id

inv_detail.dbf
------------------
inv_no -> foreign key of invoice.inv_no
stock_id
qty
price

while my friend insists the right way is:

invoice.dbf
---------------
inv_pk
inv_no
inv_date
cust_id

inv_detail.dbf
------------------
inv_fk -> foreign key of invoice.inv_pk
stock_id
qty
price

in his opinion, the key shoud be meaningless, not represent anything.

while my way (using invoice number) will cause lots of problem in the future, espesially with SQL databases.

please advise.

regards,

Jerry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform