Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relating Two Tables
Message
 
À
13/12/2005 18:01:35
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01077578
Message ID:
01077687
Vues:
39
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform