>I made a combo box From which I select a table from my supplier database. The SQL coding of the RowSource is "Select product.code, product.desc from product where product.supplier = order.supplier into cursor cProductCombo order by product.code".
>
>I found a problem that the data in the cProductCombo cannot change whenever the value of the order.supplier was changed.
>
>Would you please give me any suggestion.
If you want to get data for particular order.supplier, then you should change your select-SQL:
Local cSupplier
cSupplier=.... && entered in some control or passed from another form
Select product.code,product.desc from product where product.supplier=cSupplier ;
Into cursor cproductcombo
Thisform.Combo1.rowsource="cproductcombo"
Edward Pikman
Independent Consultant