Form Troubles

[Guest]

Hey Guys

I have a form called "Image Database Form" which has 3 parts to it

1.) Image Information
2.) Description
3.) Comments

In the Description part of my form, I would like to add a field called
Keywords in which i can add a single or / and multiple keywords. These
keywords should be recorded in a table which would link to the corresponding
image file for that keyword.

First of all how do i do this?

Secondly how do i make a search function in the form header search for
single / multiple keywords in the keyword field.

Part two

Also when searching for that particular keyword field, i would like it to
group those records with the corresponding criteria and return them to the
front of my database form.

 

[Guest]

1. Putting all the keywords in one field is a bad idea. It would be very
difficult and slow to search. You need to create a Keyword table with at
least three fields.

A KeywordPK field that is an Autonumber and the Primary Key.
An ImageFK field that has the same data type as the primary key field in
your Image table.
A KeywordDesc field which should be Text and probably about 50 characters in
size.

Create a subform based on the new Keyword table and place it on your main
form. Make it deep enough so that people can enter 3 or 4 keywords.

After all the above is done, you can search by keyword(s). You could also
filter all the records by a particular keyword using the filter by form or
filter by selection buttons on the menu bar.