Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relating Two Tables
Message
 
To
13/12/2005 18:01:35
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01077578
Message ID:
01077687
Views:
40
My actual code is:
SELECT luInsPln
SET ORDER TO ipk
SET RELATION TO	iAddrCity	INTO luCity,;
		iAddrSt		INTO luState,;
		iAddrZip	INTO luZip,;
		iCarr		INTO luCarr

SELECT Policy
SET RELATION TO iInsPln INTO luInsPln

SELECT mmPolCse
SET ORDER TO iCase
SET RELATION TO iPatRel INTO luPatRel,;
		iPolicy INTO Policy

SELECT Case
SET RELATION TO ipk INTO mmPolCse
SET SKIP TO mmPolCse
SET ORDER TO ipk
SEEK ThisForm.nCase IN Case
I noticed that the Microsoft VFP Help example is doing the same thing- it doesn't restrict the Child records to only the ones the match the Parent record until you open the Parent in a Browse window and select a record.

Jerry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform