Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET Relation
Message
From
24/05/2001 06:57:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SET Relation
Miscellaneous
Thread ID:
00510772
Message ID:
00510772
Views:
33
Hi,
I have 2 table that related with master and child relationship.

Customer
Cust_ID, Cust_Name

Sales
SalesNo, Cust_ID, Amount


Relation: (one to many relationship)
I would like to get Cust_Name once user browse Customer Sales record without LOCATE to customer table again using Cust_ID.
Any suggestions?

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform