Hi Leo Vee, Thanks a lot for your advice. Truly appreciate it. Leo Vee <[EMAIL PROTECTED]> wrote: Hi Chiat,
The usage of "display" method in report and form are different from its purpose in this case. Since you do loop one by one record in the report then your "display" method is displayed correctly. But in the form you can not achieve that based on your perspective. It is more flexible if you modify "inventTable" table to store the order number... In your case you can see the lineNum field in the "salesLine" table to display your order number correctly. This approach is quite simple. Hope this help you... Regards, __________________________________________________________ Yahoo!7 Mail has just got even bigger and better with unlimited storage on all webmail accounts. http://au.docs.yahoo.com/mail/unlimitedstorage.html [Non-text portions of this message have been removed] --------------------------------- Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search. [Non-text portions of this message have been removed]