1 Reply Latest reply on Oct 26, 2014 8:29 AM by philmodjunk

    Only get One Record in a portal, but also would like to create P

    FeldyNYC

      Title

      Only get One Record in a portal, but also would like to create P&L

      Post

      I have one painting that I bot and sold through one gallery and has one ID.  I have created 2 invoices a buy and a sell, but it is under the same Artwork ID. (I could duplicate and give it a different price)

      When I go to the Artwork Table I see the Invoice and LineItems tables through a portal of the Painting of the painting so that I see the two transactions.  That works.

      When I go to the gallery table to see what I purchased or sold through them, I only get one record.  Is this because I only have 1 Artwork ID for the piece?

      If I were to create two different artworks even though they are the same, but have different prices, how would I then be able to match them up to create a p&l?  Like if they had purchased and sold the same stock with different prices through one broker?

      Would I have to change some relationships?

      Thanks,

      Jess