Solution to prevent code duplication

Dear support team,

I am implementing a community support project in which each household will be linked to a household number. My difficulty is how to keep two different interviewers from filling in the same household code.
For example:
Household number 1 code HH01: Interviewer 1 filled in code HH01
Household number 1 code HH02: Interviewer 2 filled in code HH01 (identical code HH01)

I look forward to receiving your support.
Best regards!

Welcome back to the community, @survey_onl! Maybe this post discussed previously should help you solve your issue:

1 Like

Dear Mr, Kal_Lam,

It seems I have not solved my problem, even though I created it as you sent. Please see the illustrations and give me suggestions.
Best regards!