Reference Data Type issues

[Shanth18]

Hi,

Sometimes, when i add a reference to a field, the value (list) in the application contains a different reference data. 

Eg. In Candidates Table, I have a Job Title Reference to  Requirements table (same column name Job Title). I have another field Customer, which is referencing a field in Requirements table (same column name). In Job Title, i am getting the correct value list. But in Customer list, i am getting Job Title list.

Please advise why i get this issue. 

Thanks, Santhosh.

[TeeSee1 · Accepted solution]

https://support.google.com/appsheet/answer/10106510?hl=en

Ref column always references the key column of the referenced table.

I am guessing Job Title is the key of Requirements.

If you have Customers table, make a ref to that table instead of Requirements.

[Shanth18]

Thank you TeeSee1.