Roger
Forbes' response is good; heed it well. He's expanded on my initial
comments and has also determined that you probably need only one
table. I have one slight reservation:
In the people table you can have a field "Membership Status" which
could
contain entries like, Founder, Member, Resigned, etc
You need to consider this carefully. A founder member may resign. He/
she is still a founder (that's a historical fact) but has also
resigned. You may need to apply both of these attributes so that when
you contact your founding ex-member some years later you afford the
respect deserved by one of the founders :)
So in fact you may need two fields here: Status (current member,
resigned, lapsed, excommunicated, etc.) and Member Type (ordinary,
founder).
I'm not saying this is necessary. You have to decide on that; it's
part of the database design process.
Steve
