Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multi-Field relationships
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00196927
Message ID:
00196941
Vues:
38
>I needed to know the type of phone usage. That is the reason for field purtype ="L" or ="LD" or ="C". Your suggestion does not allow for that. The PH field (payment type) is a disbursement type. "Ph" can have one of the 3 purtype's for a single payment. That is the reason I thought purtype could be defined in the index. I am missing something by having a parent with a single index and a child with a muli-field index. Does that help clarify things. Thanks

If what you want to do is relate the 2 tables by the phone number with the child table being index on PH + PurType, you can do this with a SET RELATION TO PH INTO CHILDTABLE if Set Exact is OFF. The PH field has to be the same type and width in both tables. Or you could create an UPDATABLE view of the two tables and join them however you wish. You can even parameterize the view on the PurType field.

... [optional: Where Parent.Ph = ?lcPhone and] Child.PurType = ?lcPurType ...

All you have to do is set [optionally Parent.Ph] lcPurType = "L" [or "LD" or "C"], this issue REQUERY() on that view.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform