Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential Integrity
Message
From
25/01/2001 09:44:59
 
 
To
24/01/2001 16:57:02
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00467882
Message ID:
00468416
Views:
15
>One way is to use another field with an autogenerated integer as the PK for this table and just use the Garment and >Service as FKs to their respective parent tables.

Thanks C. W.
service and garment are childs to the same parent table. it is a pricing table for drycleaning.
Example: to find price for drycleaning, which is a service, for blouse which is a garment, you would issue "SEEK str(garment.recid)+str(service.recid)" in the parent to get the price to charge the customer.
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform