Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display values in 2nd listbox based on a value 1st listb
Message
From
17/04/2007 05:38:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
16/04/2007 12:20:20
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01216304
Message ID:
01216630
Views:
14
>I would like to display values in a second list box based on a value in the first list box. For example suppose that list box A contains the values
>
>a b
>c d
>e f
>etc
>
from table data1. Then if I click on a line in list box A I want list box B to show the files
>
>h i j
>k l m
>n o p
>etc
>
from table data2 where the triplets are based on the values a, b, c etc (i,e field data2.field = data1.field where field is a, b, c, etc. Is this possible if so.

Claude,
Can you write an SQL like:
select * from data2 where something = data1.something and ... ?

If you can then simply use SQL rowsources for both and in InteractiveChange of listA, requery listB.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform