Error Reference field not having the value when adding a record

Error Reference field not having the value when adding a record

Adding records fails when it involves a lookup field. Here's an example:

I have two forms: Participants and Surveys.

Participants has an autonumber field called Participant ID with a Deluge field name of participantId.

Surveys includes Participant ID as a lookup field with a Deluge field name of surParticipantId.

When the user updates a Participant record and submits the Participants form, the following is executed to add a survey with the Survey's Participant ID populated with the submitted Participant form's Participant ID: 

insert into Surveys
[
            surParticipantId = input.participantId
]

When the submitted Participant form's Participant ID is 1, a Survey should be added with the Survey record's Participant ID being set to 1. However, the script fails with the following error:

Reference field surParticipantId not having the value 1.