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.

Regards,

Tom.