Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Brain Lock on Selecting Records
Message
 
 
À
24/09/2017 14:35:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows 10
Divers
Thread ID:
01654533
Message ID:
01654536
Vues:
73
>Howdy experts,
>
>Hate to ask but I"m having a brain fart on this Sunday. I have a (2) tables, vendors and pocs. I want to setup a combo box where I can see the POCs based off the vendor selected in the combo box. I have a view called lv_vendorspoc.
>
>Vedor.dbf
>pk_vend_id (numeric)
>vend_name
>
>POCs.dbf
>pk_poc_id (numeric)
>fk_vend_id (numeric)
>poc_fname
>poc_lname
>
>Sorry up front...having a serious brain fart...

Assuming that the first drop down has thisform.VendorId as its controlsource, then the second drop down can have the following select statement

select * from POCs where fk_vend_id=?thisform.VendorId

In the InteractiveChange of the first drop down you can requery the second drop down.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform