I track some small time investments for an investor club in companies.
i.e. records are the company names (Apple, Netflix, etc.)
Fields are James $ Invested and Adam $ Invested
James invested $100 in Apple
Adam invested $50 in Apple and Adam also invested $50 in Netflix
I have a formula field that sums up the total amount invested in each company (e.g. Apple is $150 ($100+$50) and Netflix is just $50.
What I would also like to do is link this to another table and have James and Adam as the Records and then show the total amount they each invested in aggregate (i.e. fields would be Total Invested, and for James it would be $100 and for Adam it would be $100)
I saw this link below but it does not work for me since I have more than one field (James and Adam) linked to the same record (Apple)
I would be so grateful if someone has a solution for me
The way to do so is exactly like you described it. Have another table with the names, you shouldn’t have different fields for every name. Instead. you can link that to a 3rd table, and in this 3rd table you link the company and the name and the amount.