How to show data that is link to multiple other tables?

502 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


How can I get the Submissions Field to only show data that is related to the user AND challenge of the current record?  Right now it's showing all of that user's submissions for any challenge, instead of just the submissions that go with the challenge in each record.

3 Replies 3
7 - App Architect
7 - App Architect

Hey Holly. Which linked field is that Submissions field tied to?

It's coming from the User table which is linked to the Submission table.  Makes my head spin trying to keep it all straight!

Here's a link to the base, just test data in there right now.

7 - App Architect
7 - App Architect

Did you get this figured out? I looked at your base and it looks like your summary table is duplicating your Submissions table, rather than summarizing it. What, specifically, are you trying to summarize? The submissions by User by Challenge?

I think you probably need a junction table of User & Challenge, which you kind of already have.