Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Display values in 2nd listbox based on a value 1st listb
Message
De
17/04/2007 05:38:58
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
16/04/2007 12:20:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
01216304
Message ID:
01216630
Vues:
15
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform