Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combo box
Message
From
10/09/1999 04:33:17
 
 
To
09/09/1999 15:26:36
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00263092
Message ID:
00263280
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform