>>Hey folks...
>>
>> This should be stupid simple, but I seem to be just stupid...
>>
>> I have a list box on a Form Tab with a Row Source Type of "Array" and the Row Source of the array "ThisFormSet.so_FS.sa_Images".
>>
>> On the record selection, I want to fill it in with the results from a SQL Select:
>>
>> SELECT PADR(JUSTSTEM(imgfile), 25) AS stem, imgfile FROM a_arcimg WHERE custno = a_arcust.custno INTO ARRAY laImages
>> IF _TALLY > 0
>> = ACOPY(laImages, ThisFormSet.so_FS.sa_Images)
>> ELSE
>> .sa_images[1] = ""
>> ENDIF
>>
>> ThisFormSet.frmCustomer.CntpgfCustomer.PgfMain.page9.CntTaxCert.LstImages.Refresh()
>>
>> When I do this, I only get results from ONE record, even though the array has all of the information for all records. Why don't I get more?
>>
>> Thanks in advance!
>
>Because when you execute SELECT PADR(JUSTSTEM(imgfile), 25) AS stem, imgfile FROM a_arcimg WHERE custno = a_arcust.custno INTO ARRAY laImages it retrieves one record into your array, the one that matches the custno in a_arcust.custno.

There are multiple records in ARCIMG for each customer. Again, the array HAS multiple values, but the listbox won't show more than one!