Only get One Record in a portal, but also would like to create P&L
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?