Search based on what user inputs.

[devious05]

Im creating a database for a council, a knowledge base for their call centre and front desks.
They want to be able to search for Cats(and many other things) for example - and a list of various cat topics would come up (e.g Cat registration, cat wandering) and the people they should contact regarding each topic.
As a beginner to Access, SQL (and databases in general) Im unsure how to structure this search.
I have created a contacts table and a services table. The relationship between the two is the primary key of contacts (contact_ID).
Sorry for being such a beginner but I just cant find any really good Access resources on the net? Anyone suggest any?
Oh and please note I have to use Access 97 because they haven't upgraded yet...

Thanks in advance!

Jenna white

 

[Trendsetter]

Hi Jenna,
The way I see what you want to do is to have a combo with all the subject titles in there (Cats, Dogs, Parks etc...)
and upon selection of a subject from the combo, a listbox would be populated with all of the topics that are available for that subject, then as a topic is selected from the listbox, a form opens holding all of the available information for the user.