Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combo box
Message
De
10/09/1999 04:33:17
 
 
À
09/09/1999 15:26:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00263092
Message ID:
00263280
Vues:
18
Hi James.

>> I have two tables with a one to many relationship. when i am on the parent table record i want a combo box to show only the corresponding records of the child table. Is there a property to filter out non related records <<

How about setting the RowSourceType of the combo box to SQL and the RowSource to

SELECT Yada Nada Blah FROM SomeTable WHERE SomeField = ParentField INTO CURSOR MyCursor

Then, whenever the record changes in the parent table, all you have to do is

MyCombo.Requery()

Marcia
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform