problem with ref columns

[jpruezkiez]

hello, i am having an issue regarding REF data type, i have an employee list and attendance table, the attendance table has a column for the name, clock time, out time and day, i added an action to add a new record to the attendance table when i click it, however, it seems to add it without problem, but it's not being reference. i will provide images below:

this is the employee information

and this is the attendance table:

when i add the record manually, it gets referenced.

however i need to be able to do it automatically with an action. but when i do it when the action, that new added record doesnt get linked to the employee and appears with a yellow triangle.

the action i am using looks like this:

i really do not any approach to fix this, any tip or information that you can provide me, i would be very happy.