Multiple Level Database

I am new to Adalo. Like it so far. Am having problem with the database and creating certain records.

I am creating a child behavior management app.

I have a 1 - Many relationship with Users and Child. So a certain logged in user can create Child records. And I have that working right now.

I also have a 1 - Many relationship with Child and Privileges.

The problem is when I am trying to create Privileges records associated with a certain child. I have a drop down box in my form that lists all the children and not just the children of the user.

If anybody knows how to make this multi-level database issue work that would be great.

Hi @markhawley,

You need to use additional filters for the dropdown and set it as Child → User → Email is equal to Logged-in User → Email.