1 of 1 people found this helpful
If you have
Customer --< Invoice --< LineItem >-- Product
and on a Customer layout display a portal into lineItem, then the field Invoice::dateInvoice is resolved by looking 'backwards' into Invoice, which does not work as expected – as you see.
Solution: create a new table occurrence of Invoice and relate it to LineItem. Then place a field from that table occurrence into the portal. From the perspective of Customer, this new TO is 'behind' ('comes after') LineItem, so every LineItem record can properly resolve and display its own Invoice date By looking 'forward'.
Worked like a charm!
I had spent hours obsessing over this challenge. About two minutes after reading erolst's response, the problem was totally solved.
Thank you Eroist for taking the time to help with this beginner's question.
You're welcome. Glad to see it works for you.