Forum Discussion

JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
4 years ago

Relationships Question: 1 Parent Table to 1 Child Table - lookup/relationship to 2 Fields

Hi everyone, This feels like it ought to be a simple question, but I can't figure it out. I have built a Parent table of Communities and Regions (Region A = Communities 1, 2, and 3; Region B = C...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
You have done it exactly correct.  You might want to consider a form rule to populate the 2nd relationship with the same clue as the first selection when the second is blank, assuming that for the most part most attendees re from within their own local community.  Then the users can change it if that was not the case.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
JenniferJuhasz's avatar
JenniferJuhasz
Qrew Cadet
4 years ago
Hi Mark,

Thank you!  I appreciate your time and confirmation, and the suggestion is great.  I will do that.

Take care,

Jen

------------------------------
Jennifer Juhasz
------------------------------