AnsweredAssumed Answered

Club management database

Question asked by jasonmichel on Jun 21, 2013
Latest reply on Jun 22, 2013 by davidanders

Title

Club management database

Post

     I've kind of asked this before, but I wanted to be more specific now that I know what we need.

     I want some type of database that tracks membership and member activity for a fitness facility.  The actual membership database would store:
      
         
  1.           1/. ID (4 digit)
  2.      
  3.           2. Name
  4.      
  5.           3. address
  6.      
  7.           Phone
  8.      
  9.           DOB
  10.      
  11.           Email
  12.      
  13.           Membership start date
  14.      
  15.           Expiration
  16.      
  17.           Key Member (yes/no)
  18.      
  19.           Key code ++++-++++(8digits sep. by hyphen)
  20.      
  21.           Waiver (yes/no)
  22.      
  23.           Photo
  24.      
  25.           Would like to make it so employees have to log in

     then have a way we can setup another terminal that the member comes in and enters their ID to check in, and their picture pops up as well as some event that alerts if membership if valid or not. (like a green or red screen or backdrop of their picture)

     would like to be able to run custom reports on current members, as well as soon to be expiring.

     Also is this something I could create with FMP and have it standalone and run from the 2 machines, or will i have to have a copy of FMP on each machine that runs the app?

      

Outcomes