What are all of the requirements for a field to be set as the Key field?
QuickBase allows some but not all of my fields to be set as the key field, therefore, what are all of the requirements of a key field?
Forum Discussion
What I was trying to do was make the reference field for a child table be equal to a concatenated formula field and then match it to a concatenated formula field in the parent table which would be set as the key field. And both of the formula concatenated fields are based on lookups/reference fields. But, unfortunately, QuickBase doesn't tolerate any part of that idea. Which I find disappointing since all the fields involved in this scenario are 100% unique (unique records that is).