Is there a way to have referenced columns update each other?
For example, Table A with info about contacts, and Table B with info about companies. On the contacts table A I have a column for company, which references the companies table B, and vice versa, with a contacts column on Table B. If I add a company to one of the contacts on Table A, is there a way for this to be added to the relevant row on Table A?
I’ve found a way to display the references, with lookupRecords, but that turns the cell into a formula, which can’t be changed.
Searched the forums and help centre and couldn’t find anything about this - any advice please?