>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