Hello. I was working on a project when I came to a roadblock. I have been using record linking fields, lookup fields, and rollup fields to work with data between tables but that requires you to manually select which record connects to which. Example:
I was wondering if there was a way to get around that because there is a table that will likely have thousands of records so it would be nearly impossible for a single person to manage. This solution would preferably allow for the use of formulas as well but any solution would do. Thank you in advance for any advice!
Drawback: One issue you may run into though is if for your specific use case you need a single record ID for the values. If you just need the data for viewing this is great. If for some reason you need it to update bi-directionally across different tables with user inputs from the table where the records were duplicated, as well as the originating table, this approach can become a bit convoluted.