This video by @pford explains this issue very well.
Adalo Tutorial: Most Common Mistakes - Database Collections, Relationships, and the Infinite Menu