I'm setting up a database for my artists' collective, and trying to record and account for each member's studio use. We sell studio access by the hour (Open Workshop time). We also run classes and give student 9 hours of Open Workshop time for each week a class runs. The problem: How to set up those 9 hours so they are part of an artist's "bank" of hours, but disappear after the week is over.
You are pretty much asking for a whole solution here.
I should start with downloading SeedCodes Calendar
With that you have a good start how to manage your slots. Then it´s up to you to build a table for your customers and populate relationships with that calendar.
To learn more about FileMaker have a look at free FileMaker Training Series