Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set relationship
Message
From
06/02/2014 19:12:56
 
 
To
06/02/2014 18:59:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01593576
Message ID:
01593583
Views:
43
>>Hello
>>I have three table with a common field. Can I set the relation between these three tables and their common field? I am used to doing
>>this with 2 but not 3. Is there some way I can establish a "relationship" between 12 tables, each of which has a common field.
>
>I find using SQL and cursors much easier than anything involving SET RELATION, SET SKIP etc. I haven't used the latter commands for many years.

I still use them to verify in first step visually if I generated large amounts of data - second step is generating descriptive stats across linked tables. Often you see your gotchas in the browse relationships test without having to wait for heavy join action ;-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform