I have a pretty simple setup which doesn’t appear to work.
I have 3 databases:
The user database. Each user can have multiple ships, but a ship belongs to 1 user.
A ships database. Each ships belongs to one user and each ship can have multiple appointments.
And an appointment database. Each appointment belongs to one ships and thus indirectly belongs to one user.
What I want is to show a list of appointments to the user. It all seems pretty easy to do. Like you see here:
Just get a list of appointments from the ship that belongs to this user.
The result is this:
empty as you can see, even tho there should be 1. I have no clue how to fix this. It seems like everything should work fine right??
Thanks for your time!