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.
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