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.