Next problem :-/,
I’m trying to perform a similar process, this time taking a single line text field, using CONCATENATE() in a formula field to insert a comma at the end of the string, then copying from the formula field to a linked field (very similar to the above).
However - the copy paste from the formula field into the linked subject field doesn’t seem to work. The result is blank - this didn’t occur earlier with the student numbers.
I believe this is because the linked table has a formula as a primary key (Concats one field with another).
Is there are workaround here?
If not, then I will have to find a workaround in the linked table and remove the formula aspect there.