Design of form flow

[Mark S]

I have used Access to track twice-a-year meetings of my professional
organization for years and want to rethink the layout and design. I am using
Office Pro 2007 with Vista Ult.

The attendees are members and non members of the organization. Members of
the organization are tracked in this database (but the most up to date
member information is kept in a separate roster database).

I need to track attendee demographics, whether they will attend our social
event including payment method and addition guests (children), and what
sessions they will attend 4 of 6 choices are tracked. I will produce reports
based on the event May or December (by year).

Is it best to organize the database and group by meeting (a May or December
meeting) or by individual? Right now I track by member and use a subform on
a separate tab that shows a list of the selected events by meeting date and
session (May 2007 Session A, May 2007 session C, May 2007 Session D, May
2007 Session F).

I also wanted to better tie the Primary member database Roster with this
meeting database so member information can be updated easily.

If this is way beyond the scope of this newsgroup please tell me. Mark S
(e-mail address removed) 559 325 6850

 

[Al Campagna]

Mark,
This is a pretty "broad" question.. but...
I would track by meeting, since the primary relationship is One meeting to Many
attendees. This will allow you to go to one Meeting record, and add all the attendees on
one form.... as opposed to going to each member record, and assigning a meeting. The
Attendees would be linked to the Meeting by something like a MeetingID.
In the subform, you would simply be adding member ID's to a meeting, and any other info
the transaction requires (payments, status(guest, nonmember, etc.)...etc).

session (May 2007 Session A, May 2007 session C, May 2007 Session D, May 2007 Session
F).

This info should be two fields... in fact even three...
MeetingName Session MeetingDate
April 2007 A 4/1/07
April 2007 B 4/8/07
That will assist in reporting on meetings, by year, month,session, etc...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Mark S]

Thanks. I thought I had to make it broad because the whole issue was on
general design. I had done it based on individual physician and it worked
but seemed cumbersome and harder to read updates after multiple years. Let
me tinker. M Simonian