Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Visual Promatrix with the existing application
Message
 
 
À
10/07/2009 16:45:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual ProMatrix
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01408759
Message ID:
01411522
Vues:
37
>Hi Naomi,
>
>VPM follows standard RI theory. There can be many candidate keys (unique value per record); but only one primary key, which functionally is also a candidate key, but is the one and only key used for relations among tables. There is nothing you can't do following that conceptual scheme that you would do with movable primary keys. Just follow standard RI theory, and VPM will work with you.
>
>Hank
>

Hi Hank,

I may be wrong, but I believe in RI theory you can have the same table different key engaged in relations.

E.g.

Child1 FKField
Parent PKField1

Child2 FKField2
Parent PKField2

However, I'll ask someone also to make sure - I'm somewhat not certain here.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform