Multiple keyword list

[ajoyprabhu]

I am trying to setup a VERY SIMPLE database to track my collection of slides.

I will have (probably) ONE table with the details of the slide and another with a list of keywords. For example:

TABLE#1
Image#, Date, Time, Place, Keywords(?)

TABLE#2- Keywords
Keywords (such as flower, people, pets)

What I want to be able to do is to have a pulldown (combo box) to access multiple keywords in a form AND MOST IMPORTANTLY, be able to search for say, flower and people to pull up all slides (records) with these two keywords. I know it is simple, but not for me!

Thanks a million to the responder!

Ajoy

 

[ajoyprabhu]

I forgot the most importnat part, I need to create the keyword list in a tree form, in other words..

Landscape
Mountain
Lake
River

Travel
Building
Train
Riverboat

etc. this way, if I search for Landscape, I soudl be able to pull up the entire subset, i.e. mountains, rivers etc.

Thanks!

Ajoy