Re: Multiple one to many relationships

714 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there,
For an upcoming conference, people submitted around 150 abstracts.
Each one has been reviewed, with a numeric score and optional text content.

So each abstract is a singular thing, with one average score. But each abstract has multiple comments
And each reviewer is one person, but has multiple comments.

I kind of think this page:

is what I’m looking for but I got lost after pretty much the first step.
Do I need a junction table? Multiple junction tables?
Is the example at the bottom of the page, Example 3: Clients, client orders, products, and manufacturers, what I’m looking for?


2 Replies 2

Hi @John_Bakum - A junction table is the right way to go here. You’re trying to track 3 different entities here - abstracts, abstract comments and reviewers - with the following relationships:


  • has many : comments


  • has many: comments


  • belongs to: abstract
  • belongs to: reviewer

Additionally, an abstract has many reviewers through comments and a reviewer has many abstracts through comments. So, comments is a junction table and would look something like this:

Screenshot 2020-01-23 at 07.22.06

Text comments and rating scores (total or average) could be pulled back to the Abstracts table (lookup/rollup fields) or back to the Reviewers table.


4 - Data Explorer
4 - Data Explorer

This was super helpful, thank you so much!
I have set it up as you described and it’s working.