Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ListBoxes & Set Relation
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00480943
Message ID:
00480957
Views:
10
>Hello All,
>
>I have a form with 2 listboxes bound to 2 different tables (Rowsourcetype alias) which are related to each other.
>
>When I move in the first listbox I would like to see the filtered subset in the second listbox - but for some reason the second listbox ignores the set relation (it shows all the records all of the time).
>
>I could do it with a SQL where clause but that means i'm working with a cursor which makes table updates more hassle.
>
>Anyone have any suggestions?

I use set relation sometimes and have found that when I move the parent table I need to Select the child table just to wake it up to show what it is supposed to do. You might try that. When you move in the first list box then select the child table and refresh the second list box programmatically.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform