Key and Parent Key Issue

Support
1

1. What is the issue? Please be detailed.

Excel as database.

Why does PARENT KEY column in Repeat sheet contains "Keys" the does not exist in KEY column in Main sheet

2. What steps can we take to reproduce this issue?

This is normal the condition
Main sheet (KEY column) = Repeat sheet (PARENT KEY column)

  • My Main sheet contains Name, Address, Contact details data
  • Repeat sheet contains data from question.
  • In order to connect the two sheets (Main & Repeat) I need use the "Keys" and both of the sheets have this.
  • the problem is, Repeat sheet contains Keys that doesn't exist in Main sheet.

3. Upload any forms or screenshots you can share publicly below.

11 Keys from Repeat Sheet does not exist in Main Sheet

image
image1269×710 31.9 KB

2

Your context seems a bit unclear... Should this be directed instead at the (unrelated) ODK-X Support Forum?

3

Hi Sir, good afternoon. I'm sorry for a confusing post.

Sheet1 = "MAIN sheet"
data-partxx = "Repeat sheet"

image
image1337×45 2.29 KB