New Search Form

[Silver76]

Hi guys

I have created a database to hold photo images. This is how it is set up.

Form One = Image Information (This holds a photo and some information)
Subforms 2 = Image Description ( This holds a text field containing keywords)
Subform 3 = Image comments (this holds information for Author and comments)

I would like to now create a search form that can search under the keywords
and brings up only the image files that applies to that keyword. First of all
is this possible ( I am gathering in access it is) and if so have i set up
the database to be able to do this and how do i then create a form to do this.

Cheers guys if you need any more information please let me know.

 

[Allen Browne]

Presumably you have set up tables like this:
- Image table (one record per photo, with ImageID primary key)
- ImageKeyword table (with ImageID foreign key)
and then created a one-to-many relation (so one image can have many
keywords.)

Your Subform2 therefore has many rows with one keyword in each row (if an
image has many keywords.)

If that's what you have done, you have the correct relational design.

To see how to query the images that have a matching keyword in their
subform, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html