>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