# Database relationship issue

**URL:** <https://forum.adalo.com/t/database-relationship-issue/46857>\
**Category:** Database\
**Created:** [April 19, 2024, 3:57pm UTC](https://forum.adalo.com/t/database-relationship-issue/46857 "2024-04-19T15:57:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kward.suffolk](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@kward.suffolk](https://forum.adalo.com/u/kward.suffolk)\
**Post date:** [April 19, 2024, 3:57pm UTC](https://forum.adalo.com/t/database-relationship-issue/46857/1 "2024-04-19T15:57:23Z")

</div>

Hi!

I am trying to create a 3-tier Database relationship utilising the Collections in Adalo. I am runing into a problem with the 3rd tier Collection showing the association to the top tier instead of the middle tier. For clarity . . .

Collection 1: Users (Top tier)

Collection 2: userData (many “userDatas” to 1 association to Users)

Collection 3: dataItems (many “dataItems” to 1 association to userData)

I have 1 user row (user ID = 35)

I have 3 userData rows (all associated to user “35”), ID’s = 1, 2 & 3

I am trying to create dataItems to associate to one of the 3 userData rows, but the selection drop-down for association shows 35, 35, 35 (the top-level Users association instead of 1, 2, 3 which is the association I wish to make.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/9/8/980d2a3de6d47928d33ce1ffd43745be6901c69f.png)

Shouldn’t that 3rd tier table be referencing the Id’s of the middle table (as that’s it’s many to 1 association)?

Any help is appreciated!

Thank you.

-Keith