Is there a way to pass a calculated value into a Field linked to another table?
Here’s an example.
Table A
Field 1
Field 2
Field 3 [linked to Table B]
Table B
Field 4
In Table A, I want to auto-set the value of Field 3 = Concatenate ({Field 1}, “, “,...