>select products.product from products into cursor lproducts order by product
>
>the control source is: m.product
>
>In my method I have a select sql statement:
>
>I pass it a value depending on what hotkey a user presses
>
>parameter m.hotter
>
>select hotlist.hotlistid, clients.clientname, grades.grade, products.product;
>from hotlist, clients, products, grades;
>where hotlist.hotlistid = hotter;
> and hotlist.client = clients.clientcode;
> and hotlist.prodcode = products.prodcode;
> and hotlist.gradecode = grades.gradecode;
>into cursor cltest
>
thisform.cbo.displayvalue = cltest.product
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California