Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The best way of displaying surrogate foreign keys
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00175383
Message ID:
00175469
Views:
33
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
Previous
Reply
Map
View

Click here to load this message in the networking platform