# Getting confused with relations
**URL:** https://community.glideapps.com/t/getting-confused-with-relations/4325
**Category:** Ask for Help
**Created:** [February 6, 2020, 2:27pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325 "2020-02-06T14:27:11Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)
#### Post date: [February 6, 2020, 2:27pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/1 "2020-02-06T14:27:11Z")
Hey Gliders,
I have been banging my head against the wall for a day trying to figure this out but I am really struggling. Perhaps I am just too close to it and aren’t able to see clearly. I am sure I did things like this in the past with ease.
Here’s a copy of my spreadsheet without the real users’ data.
> **[Book thingy](https://docs.google.com/spreadsheets/d/1j30rYF5oi4nxdjVwH7I2S5IEEV1g_de3cSpCvwPO8L4/edit?usp=sharing)**
>
> Users
>
> user ID,Username,Picture,First name,Middle Names,Last names,Registration date,Notes,Accepts terms,Status,First and Last,Contact for research?
> 1,user1@mail.com,John,Wick,08:05 04/12/2019,Complete,John...
My app is structured in the following way.
There’s a reading list Tab where users can add books.
To each book, they can add notes
There’s a Books tab that is a copy of some entries on the Reading list but removing any duplicates.
What I am trying to achieve is that users come to the books tab \> learn about the book and see that other users have written notes about that book \> click on a users name and see a list of the notes that user has written on the book only \> click on a specific note and read it.
   
I’ve tried many ways, right now what is happening is that both Nugget Notes user and Laura are displaying the same results despite the notes being from Nugget notes only
 
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 7, 2020, 5:44am UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/2 "2020-02-07T05:44:24Z")
Can you share how your relations are set up? How is the relation from Book to User and the User to Notes set up. I’m having a hard time visualizing that part.
---
### Author:  [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)
#### Post date: [February 7, 2020, 10:57am UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/3 "2020-02-07T10:57:14Z")
Hi Jeff, thanks for having a look at this.
To be honest, these relations are now all over the place because I was trying to solve it
Users has relation with Notes matching username and author
BooksAvaialable has relations with:
- Reading list - matching Title and title
- Notes - matching Title and title
- PublicNotes - matching Title and title
ReadingList has relation with Notes - matching BookID and BookID
Notes has relation with Users - Marching Author with Username
PublicReadingList has a relation with:
- Notes - Matching title to book title
- PublicNotes - Matching title to book title
- Users - Matching user with username
- PublicNotes - Matching User with Author
---
### Author:  [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)
#### Post date: [February 9, 2020, 4:49pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/4 "2020-02-09T16:49:47Z")
Did this make any sense to you?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 9, 2020, 5:23pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/5 "2020-02-09T17:23:45Z")
There’s a lot going on here and I’m trying to keep it straight in my head (haven’t had my coffee yet). If I understand correctly, the Books tab is pointing to the PublicReadingList sheet. You select a book to view it’s details. Which relation are you using to show the list of users within the book details?
---
### Author:  [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)
#### Post date: [February 10, 2020, 4:20pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/6 "2020-02-10T16:20:20Z")
PublicNotes
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 10, 2020, 6:52pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/8 "2020-02-10T18:52:58Z")
Sooo, that’s a no go on getting it to work? 😉 I’ll take a deeper look tonight.
---
### Author:  [@Sandro\_Brito](https://community.glideapps.com/u/Sandro_Brito)
#### Post date: [February 10, 2020, 7:03pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/9 "2020-02-10T19:03:56Z")
No, got it working! Had to create a new relationship and worked. Thank you so much for you help.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 10, 2020, 7:57pm UTC](https://community.glideapps.com/t/getting-confused-with-relations/4325/10 "2020-02-10T19:57:11Z")
Awesome! Glad you got it figured out!