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 !!!!