6 Replies Latest reply on Mar 17, 2009 5:23 PM by jlarmen

    One customer, multiple purchases how

    jlarmen

      Title

      One customer, multiple purchases how

      Post

      Ok, I've got a working invoice (isn't this addictive?).  I have a CUSTOMER table (Cust ID, etc...), an ORDER Table (Cust ID, Order ID, Order Total), ORDER LINE (Order ID, Product ID, Qty, Ext Price), INVENTORY (Product ID, Desc, Price).  Relationships are set as: 

       

      CUSTOMER::Customer ID ------<ORDER::CUSTOMER ID

      ORDER::ORDER ID ----<ORDERLINE::ORDER ID

      ORDERLINE::PRODUCT ID -------<INVENTORY::PRODUCTID

       

      I have a layout called customer which has the customer information and a portal with related records from ORDERLINE.  This works so far and everything is matching up.  What I'm realizing that I need is to separate the customer so that I can add a different invoice to the same customer.  Since each customer can have different purchases on different days, how can I set up a layout so that the customer stays the same, but allows the creation of a different 'portal' of purchases/records.  Right now I have a 'create a record' button on the customer layout to create a new purchase but it requires the entering of the customer data again creating two customers with two different 'purchases'.  Am I making sense?