By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,925 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,925 IT Pros & Developers. It's quick & easy.

Setting up a contact list

P: n/a
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

I'm doing this in MS Access 97.

Thanks in advance for any suggestions!
Dec 16 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.