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;
My aim is to ensure that an invoice is saved as one unit and not saving the master and the details individually. If there is another workaround i will also appreciate. 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/
