Form/DB design

[claven123]

I volunteer for a local fire department. We have several committees and several members belong to these 10 committees. So, each member may belong to several of these and one member is the chair. Every so often the chief will adjust these and post a page with the committees listed and under each one the names of the members.

I have started making a db for the members of the FD and have made the roster and some other forms.

I would like to know the best way to do the committee in design to get the output required. I would like to be able to click a cmd button and get the output in either word or a report that recreates the committee form that is populated by the main form for the members.

I can do an export to a template in word etc... and make a report. I would also like to show who is the chair for each committee.

I hope this makes sense. I have looked at doing it several ways with yes/no also combo boxes and separate tables for the committees etc...

Thanks,

Dennis

[ssanfu]

On the microsoft site

http://office2010.microsoft.com/en-u...24.aspx?av=ZAC

there is a template for "Meeting Tracker". Maybe it will have something you can use.

[orange]

From a tables perspective, I think there would be 3 tables
1) Member
with MemberId PK
MemberName
MemberAddress
MemberPhone
other field specific to Member

2) Committee
CommitteeID PK
CommitteeName
other fields specific to Committee

3)CommitteeMember (a junction table)
Composite key made up of (MemberId + CommitteeId)
ChairmanId

In Table 3 ChairmanId would be the MemberID of the person who is Chair.
However,because you say the membership may change from time to time
you will have to identify which session of this Committee is being identified.
That could be something like StartDate-EndDate, or a separate ID.
This ID would be a separate ID for the junction table - every time there is a new
"version"/"makeup" for the committee then the Id would get incremented.

I hope this helps in structuring your database tables.

Edit: I now realize that ssanfu has answered while I was typing. I agree that if you
can find an existing model that meets your needs, then go with it.

[claven123]

I'm a bit confused on this. I didn't see what I needed from the link, sorry.

This might be just a bit too difficult to do. I'll keep looking at this.

Dennis