Two fields different Variables

[Guest]

I have tow fields or columns, what ever you wish to call them.

The first has products, by name
Hats, shoes, etc

The second has product definitions
Hats hunting
Hats ball
Shoes low tops
shoes High tops

I Know this sounds silly, but it is the way my miva matches things, In my
database, I would like to match these fields via words. Hats = Hats etc

Is there a way to do this?

access newb

 

[Joseph Meehan]

I have tow fields or columns, what ever you wish to call them.

The first has products, by name
Hats, shoes, etc

The second has product definitions
Hats hunting
Hats ball
Shoes low tops
shoes High tops

I Know this sounds silly, but it is the way my miva matches things,
In my database, I would like to match these fields via words. Hats =
Hats etc

Is there a way to do this?

access newb

Could you give that to us again. I just don't understand what you want.
What do you mean "match fields via words"

 

[Guest]

Field1 Field2
Joe Hats Hats (auto fill when matched by
keyword)
Tractor Hats Hats
Steel Toe Boots Shoes
Steel Toe Shoes Shoes

This is an Example of what I would be looking for

 

[Douglas J. Steele]

Steel Toe Boots matching Shoes isn't going to happen unless you have a list
of synonyms stored somewhere.

For the others, you can use

WHERE Field1 LIKE "*" & Field2 & "*"