list item click to bring up info into another listbox

[Octagon6]

The following code I have is in the click event of a list box. When the dispatch_num is found in this one table, it is supposed to send the info into another listbox. The problem is that it can only find the first record in the table.
LOCATE FOR stopovers.dispatch_num = update_disp
IF FOUND() THEN
SELECT * FROM stopovers WHERE stopovers.dispatch_num = update_disp INTO ARRAY aStop
ELSE
aStop = ""
ENDIF

 

[EzLogic]

Test the length of the array ALEN() and see if there are more than 1 record in there.

If so, you might have problem with the controlsource of the listbox.



Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan