Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relation in the dataenvironment
Message
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00736265
Message ID:
00736331
Views:
10
You're better off using Surrogate Key (B) as opposite to Natural Key (A). The Surrogate Key is usually integer field with sequential autogenerated values. BTW, VFP8 natively supports such fieds. See http://fox.wikis.com/wc.dll?Wiki~SurrogateKey for more details.

>Please give me an advice
>
>
> Which kind of field is good to use as ID in the father table for creating the relation to the child talble ?
>
> A)The number of client, which is a field that can be edited
> by the user
>
> B)A hidden field that the user can't access
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform