Banging my head on a wall about this one... I have three tables: members, boats, slips. Every boat is owned by a member so there's a Related Boats column in members. Each boat is assigned to a slip, so there's a Ref column in slips for assigning a boat to a slip.
In a table view of members, I have a virtual column to display the boat(s) names. I would also like to display the related slip names, but I can't quite figure out how. If it was MySQL, it would look like this:
Select member_name, boat_name, slip_name FROM members
JOIN boats on boat.owner = members.id
JOIN slips on slips.boat = boats.id
What would be an appsheet formula that returns a list of slips associated with boats owned by the member?
LinkedIn
Twitter
