Here’s the aim.
We have a marina we’re managing. There are numerous “Slips” that “Customers” are referenced in as such:
A1 = John Doe
A2 = Jane Doe
We have a crew that goes out a few times a day, and logs if the boat that is supposed to be in the slip is there or not.
I’m trying to set it up so the crew’s information is as up-to-date as possible, and end up with a report the coast guard could look at to see when boats were in, or not in, their proper slip.
Very open to ideas.