I have two list box in the form, i have a set record called trn.dbf
and bill.table, trn.dbf contains invoice no,stockcode,description,unitprice,quantity,amount and bill table contain invoice no, date,customer,discount,total amount.

how to list this invoice's details such as stockcode,descrition,quantity,unit price,amount into the list box on the right hand side.

Once I press Command button like > , the stockcode,description,unitprice will go to the list box on the left hand side, and then quantity will increase one by one once i press down the command button. or i press command button >> all quantity will go to list box.

How to lock the record once other user access the same invoice no.


Coding will be appreciated. Thanks !!!!