Forum Discussion

Qrew Cadet

3 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

JenniferJuhasz

Qrew Cadet

Just updating this - I've attempted to do this by creating a Second Relationship; The relationship itself is identical except the reference field is a different field. It "seems" to work, but I recall in a training being told that it's not a good idea to have two relationships; but in that instance it was for creating a many-to-many relationship, which is not what I'm doing here.
Can anyone tell me if there is a reason why this would "not" work?

Thank you!

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

MarkShnier__You

Qrew Legend

3 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
Qrew Cadet
3 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
------------------------------