Bidirectional/two-way references

[Sqasl]

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?

[Mr-Rooj]

@Sqasl

ach 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?

Im also curious about this.

[BiBo]

@Sqasl I think you need simple Many to Many relationship.
I create example for you.
This what you want?