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

Question

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 = Communities 4, 5, and 6; etc).This is connected to a Child Table of attendees to online events.  I want to relate to two fields within this single Child Table: To both the Community the Event was intended For; AND to the Community the attendee Lives in.  I can only seem to get it to relate to One of the two fields; not both.  Is it possible? Or do I need a secondary table of communities to make this happen?  Thank you for any suggestions you have!Jen------------------------------Jennifer Juhasz------------------------------

JenniferJuhasz · Answer

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
------------------------------

Sign up

Login to the community