0

Display records from second relation table

Here's my current situation: I have a table for events, a table for teams, and a table for contacts. I really need to get the contacts from the teams for each event listed on the events form view. There are a lot of teams and around 2-3 contacts per team, plus teams compete in multiple events. Can this be done easily? 

I'm coming from Filemaker, which is really straight forward (to me) on how to display everything because you can connect things easily through IDs through multiple tables easily, so I'm feeling lost with a lot of this.

1 reply

null
    • Ninox
    • Bilguun_Gantulga
    • 3 yrs ago
    • Reported - view

    Hi Sarah,

    so if I understand you right, you have table for events. In this table there are team entries from the team table and these team entries have in their own table also multiple contacts? If I get it right now you want to display all the contacts related to the team members in your event entry?

    If this is right, the solution is really simple. All you have to do is to insert a view field in your event table. As a function you just put the code: Teams.contacts or Team.contact, depending on how you named it in the field and that's it. Do not use the 'select' statement because you want to have event related entries.

    Best Regards

    Bilguun

Login to reply

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 580Views