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?
Can't really answer here without knowing exactly what relationships are in place and the context set up where you are trying to view this data. It might be as simple as modifying your layout setup to refer to a different table occurrence.