Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The best way of displaying surrogate foreign keys
Message
 
À
13/01/1999 08:25:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00175383
Message ID:
00175469
Vues:
34
I'm not sure I follow you.

Let me try to simplify. You have a parent table, PARENT.DBF. You also have a child table, CHILD.DBF. The CHILD.DBF has a column called ID, which is its primary (surrogate) key. CHILD.DBF also has a column, FNAME, a "user friendly" description of the "unique thing" about this record. For this example, I'll use first names. The PARENT.DBF has its own ID column. ID is PARENT's Primary (surrogate) key. CHILD.DBF also has a column called PARENTID, which holds the surrogate/primary key from its related parent record.

Are you asking how to give your users a form which will allow them to view the values from the PARENT record along with the related FNAME's from CHILD.DBF?
Marty Smith, CSQE
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform