Quick option would be to have a single
Text field and list all the interest & hobbies therein.
Create a query with criteria set to a
parameter in the format:
Like "*" &[Enter
Hobby] &"*"
That would search though the field * find
all the records that match your criteria.
Regards
Norman Pearce
IT Training Manager
Ealing Hospital
T: 020 8967 5085
E: [EMAIL PROTECTED]
Developing the foundations for your success
-----Original
Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 01 November 2005 17:45
To:
AccessDevelopers@yahoogroups.com
Subject: [AccessDevelopers]
Options or Yes/No fields use
Hi
all
I am designing a database for my use as a travel
agent. It is intended to be a CRM type database. I want to track my
prospects and clients interests and hobbies. I have come up with
about 60 different selections. I want to be able to run a query and do a
mailing based on these interests and hobbies, eg. all persons who are
interested in ballroom dancing.
The only solution I have been able to come up with
is have the 60 selections as Yes/No fields in the client table. I thought
about have say 15 max fields and then have a lookup where the 60 selections
would be in another table and could be selected for each of the 15
fields. However this creates a many-to-many relationship.
Keep also in mind that I will sooner or later have
this application on my web page so my prospects and clients can enter their own
information using a user name and password.
Any ideas, opinions, and comments would be most
appreciated.
James F. "Jay" Beckham, Travel
Consultant
World Class Cruises & Tours, Inc.
2799 Highland Ridge Road
Berkeley Springs, WV 25411
304-258-4451
www.wccruises.com
"You're Not Dreaming, You're Cruising"
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
YAHOO! GROUPS LINKS
