Creating a contact list

[rjbonn]

I'm setting up a contact list for a musician, who is about to release
her first CD.

She would like a contact list that can track the people she meets, who
will be in various categories -- fans, radio station personnel, owners
of clubs, other musicians, etc.

Ideally, I'd like to create a form that asks basic questions for
everyone (name, phone number, etc.) No problem. But then, there will
be different kinds of information, depending on what type of contact it
is. If it's a musician, what instruments do they play, are they in a
band, etc. If it's somone affiliated with a radio station, what are
the call letters, what's their job, etc. And of course, she may meet
more than one person at the same radio station, and she doesn't want to
enter the radio details twice.

I have two questions:

1. How do I set up the tables for the radio station people, so that
after all the information is entered for the program director (for
example -- the call letters, AM or FM, format, etc.), it would only be
necessary to fill in a few more fields to add a new contact at the same
station, such as a DJ? And, of course, generate a report showing
everyone she knows at a given station.

2. In general, what's the most elegant way to set up the main contact
entry form? I've been thinking of making buttons for each type of
contact (fan, radio, club, TV, etc.), and each button would open a
related form. But again, I get back to the question of what happens
when a second contact is added to a radio station that's already in the
database?

I'm doing this in MS Access 97.

Thanks in advance for any suggestions!

[Tom van Stiphout]

On 15 Dec 2006 13:20:26 -0800, rj****@snet.net wrote:

In a similar situation I recommended my friend to use Act!
(www.act.com). He is very happy with the decision.

-Tom.

>I'm setting up a contact list for a musician, who is about to release
her first CD.

She would like a contact list that can track the people she meets, who
will be in various categories -- fans, radio station personnel, owners
of clubs, other musicians, etc.

Ideally, I'd like to create a form that asks basic questions for
everyone (name, phone number, etc.) No problem. But then, there will
be different kinds of information, depending on what type of contact it
is. If it's a musician, what instruments do they play, are they in a
band, etc. If it's somone affiliated with a radio station, what are
the call letters, what's their job, etc. And of course, she may meet
more than one person at the same radio station, and she doesn't want to
enter the radio details twice.

I have two questions:

1. How do I set up the tables for the radio station people, so that
after all the information is entered for the program director (for
example -- the call letters, AM or FM, format, etc.), it would only be
necessary to fill in a few more fields to add a new contact at the same
station, such as a DJ? And, of course, generate a report showing
everyone she knows at a given station.

2. In general, what's the most elegant way to set up the main contact
entry form? I've been thinking of making buttons for each type of
contact (fan, radio, club, TV, etc.), and each button would open a
related form. But again, I get back to the question of what happens
when a second contact is added to a radio station that's already in the
database?

I'm doing this in MS Access 97.

Thanks in advance for any suggestions!