Help me count the invalids.
May 10, 2011 3:03 PM Subscribe
Help me solve a database design stumbling block. How can I track # of consecutive absences in my membership attendance database?
posted by jlowen to Computers & Internet (9 answers total)
I am designing a filemaker pro database for an organization whose bylaws state that any member who misses three consecutive monthly without being excused meetings is dropped as a member.
I've created separate table for meetings (one record for each meeting), attendance (one record for each member for each meeting attended - possible values are Present or Excused. I assume no record = absent.), and members (with all their personal data). All tables relate to each other appropriately.
My first instinct was simply to count the number of days since a particular member has appeared at a meeting rationalizing that any value greater than 90 days would make them invalid. This fails hard though when the organization decides to skip a monthly meeting as happens once or twice a year.
How would you design the db to count number of consecutive absences without calculating based on number of days?