Here's one that's confounded me so far....I have a grid with one field - a combobox control. the rowsourcetype is set to 3-SQL statement and the rowsource is:
select haulername, haulerid from hauler where haulerid not in (select haulerid from customerhauler where customerhauler.customerid = l_cust) into cursor l_haullist
l_cust is a variable set in the calling program and is changed whenever the customer record is changed (in the form.refresh method).
The combobox is doing a select of the grid being edited. The end result is supposed to be that if 3 of the 5 choices are already showing within the grid, then only show the other two as possible choices within the combobox.
The sql code works at the commandline, but gives all records for l_cust during program execution.
Any suggestions?
Thanks in advance
Steve Howie, owner
DaSH Technology
Denver, CO