Action to set rows in another table won’t set reference column

[Mbolamu]

I’m trying to create an action that creates a new row in another table and sets each column to the same values as the first table. All of the columns work except the table ID column and I think this is because it is a reference type in the second table and just text in the first. 
Is there a way around this? I need the ID to be filled in by this action so that it will create a relationship to the first table.

[Marc_Dillon]

Can you show more details? What is [Lecture Note ID]? Why are you wrapping it in LIST() and ANY()? That seems wrong. What is the base type of the Ref column?

[Mbolamu · Accepted solution]

The base type of the ref column was just text. I managed to fix this with a LINKTOFORM() filter Expression 👍🏾