I have two Access tables namely Invoices (Invoiceno, Invoicedate, Customerid) and InvoiceItems(Invoiceno, ItemNo, Description, Quantity, UnitPrice). InvoiceNo in Invoices is an autonumber. In my application, i want the number to be availed only after the user clicks Save button. As such i have used batch updates (ADO). The form seems to work fine when the user is adding the invoice items, but when one clicks Save, the invoice items disappear. The save button has two lines of code to save the changes: tblInvoices.UpdateBatch; tblInvoiceItems.UpdateBatch;
Any assistance will be of great use. I'm on Delphi 6. Phil ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
