Results 1 to 3 of 3

Thread: Append queries

  1. #1
    Join Date
    Nov 2012

    Unanswered: Append queries

    Hi, Sorry Im quite new to this.

    I am trying to create for our company a form where you insert an initial quote to send to a customer and when they agree to it we raise a Sales Invoice.

    have a tick box on the Sales Invoice form that will run two append queries to insert the data from tblQuote into tblSalesInvoice and from the subform of details order from tblQuoteDetails to tblSalesInvoiceDetails

    The tables (Quote and Quote Details) (SalesInvoice and SalesInvoiceDetails) are linked together by one to many relationships, the problem I have is that when the data is placed into each table from the Quotes tables it doesnt link the tables together via the SalesInvoice primary key. Is there a way to do this?

    Any help would be good

    Thanks in advance

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    It sounds like you're not including the SalesInvoice pk field in your append querries. Please post the SQL for your querries.

  3. #3
    Join Date
    Nov 2012
    Hi Rogue,

    Thanks for the quick reply. You are right I hadnt got the PK in it, it works now!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts