*list1 properties:
.rowsourcetype = "6-Fields"
.rowsource = 'bill.inv_no,date,cust_no,discount,total_amt'
**********
*list2 properties:
.rowsourcetype = '3-Sql Statement'
.rowsource = "select stock_code,descriptio,quantity,amount from trn where inv_no = trn.inv_no into cursor temp"
**********
*command click:
thisform.list2.requery()
**********
Remarks: instead of using listbox to display the result, try the grid class. At least you can format the the numeric fields.