I am 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 all 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), 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? And, is there a better way to do it, rather than
buttons?
I'm doing this in MS Access 97.
Thanks in advance for any suggestions!