Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Brain Lock on Selecting Records
Message
 
 
To
24/09/2017 14:35:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 10
Miscellaneous
Thread ID:
01654533
Message ID:
01654536
Views:
75
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform