External ID file connect with Program

Hi Team,

Good Afternoon,

Hope all of you stay safe and healthy at home.

Let support I am doing multiple center studies I have ID part file more than 121 lines. Can we connect ID external file with ODK program?

I need an ID part will match with each row as I have mentioned in the excel sheet. If interviewer enter the wrong value (mean 2nd-row value instead of 1st-row value) then it will not accept.

I am enclosing my file for your ready reference.

Thanks & regards,

Test_ID_Part.xlsx (19.5 KB)

It looks like you may just need a cascading select? See the following: