I have a Sales Order layout that can have many line items related to it. I also have an Invoice layout that can also have many line items related to it. The Invoice line items may or may not all be related to the same Sales Order.
On the Sales Order window, I would like to have a portal show all invoices that are associated with it.
In the Invoice table. I have used the List() function to gather all of the Sales Order numbers from the Invoice line items table. Normally I could use a text field of values for the right side of a relationship, except I cannot index the List() calculation field. If I change it to a Calculated Value text field, how can I get it to update (recalculate) automacally when an Invoice item is added?