Hello!
Background: I am building my app with a preexisting database. Two tables reference each other: Lakes and LakeChains. A Lake can occasionally belong to more than one chain, and a Chain (by definition) has more than one Lake in it. I cannot for the life of me get the ref to pull an enumlist of Chain Names from the Chains table without those yellow exclamation marks.
Question: (this might be where my confusion creeps in) when i create a new row for a new lake in the Lake table and choose a chainname from the enumlist drawn from the Chain table, is it required to save the chain Key (uniqueID) to the Lake table, rather than the label(name of the chain)? Do I need to go into the Lake table in the existing spreadsheet and change all the Chain Names to the value of the Key instead?
LinkedIn
Twitter
