I want to get a better understanding of what sort of entity a SHARE is...
On the SHARE table/ matching layout you should be able to show the CUSTOMER portal. It will only show the customers where in the Orders the Share_id matches.
Similarly on the Customer table you can show the SHares portal.
In Orders, you have a summary field for total of Quantity. When shown from either Share or Customer tables... the total should be correct.
Thanks Michael, That's the last thing we need....