I am making a table of companies which then list the investors in that company as a multiple select field - like ABC Company as the record name, and then “DEF Fund,” “GHI Investor” as the selected investors. I want to then import a new list of companies and investors, which would only add new ones to this list - not overwrite the existing fields - in this case, lists of investors are often incomplete so ideally I could import multiple lists of investors and companies and capture all the investor names.
So for example, if I imported a list of investors and companies to the base above, which showed that that “DEF Fund” and “JKL Fund” were investors in ABC Company, I’d like the result to be all three - “DEF Fund,” “GHI Fund,” “JKL Fund”. It just adds the new ones, doesn’t remove GHI Fund because it wasn’t in the new list - only additive.
Any thoughts on how to do this? Thanks in advance for any ideas!