Inventory and Invoiveing- Followo for Steve Schapel

Discussion in 'Microsoft Access Forms' started by Guest, Oct 28, 2003.

  1. Guest

    Guest Guest

    Hi Steve,

    I did create an invoice table with feilds as :
    InvoiceNumber (a code is used to generate invoice numbers)
    primekey, CustomerName, and InvoiceDate. Another table,
    tblTransaction, has PartNumber, PartDescription,
    UnitsPrice(comes from another table), etc.

    frmInvoice is continous and frmTransaction is now a
    subfrom on frmInvoice. There is an error with duplicate
    prime key. I guess my question is, whta must be the Prime
    keys for these two tables? I have AutoNUmber as the
    PrimKey to tblTransaction and InvoiceNUmber as the
    PrimKey to tblInvoice.

    Reards,

    Mike
     
    Guest, Oct 28, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike

    Inventory - Followup for Steve Schapel please

    Mike, Oct 28, 2003, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    166
  2. Sandra

    To Steve Schapel, another question?

    Sandra, May 30, 2004, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    162
    Sandra
    May 31, 2004
  3. Guest

    Steve Schapel: Linked fields error

    Guest, Nov 10, 2004, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    158
    Guest
    Nov 10, 2004
  4. StopThisAdvertising

    Stop Steve, the advertising machine

    StopThisAdvertising, Apr 14, 2005, in forum: Microsoft Access Forms
    Replies:
    36
    Views:
    425
  5. Guest

    Update for Steve Schapel, Tina, others

    Guest, Oct 3, 2005, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    167
    Guest
    Oct 3, 2005
Loading...

Share This Page