Hi, this is my first question, ever - really appreciate the support in advance. I am also a new FMP user - I started developing last December! Went through all of the online videos on FMP site, some Guy Stevens, Mark Osborne etc!
I am building an app where I have a harbour (think marina, many boats, only one can be assigned to one location (slip) at any time. I've build a layout that looks like the harbour (screen cap below) and what I would like to do is help the Harbour Master place boat for the upcoming season.
My tables are; MEMBER (the owner of a boat), BOAT (the make, length etc), SLIP (the location where the boat will be docked). Relations are MEMBER -> BOAT -> SLIP. I have this part working, I can list the slips and get boat / member details...
What I would like to do is, for each slip (the white key below - looks like a piano!) have a drop down where I select the BOAT, then that BOAT will not appear again until deselected while assigning boats to the remainder of slips.
I'm having a bit of mental block as to how to do this - but what is entirely new to me is the ability to have something assigned and not appear in the dropdown once assigned..
Thanks very much.