Two fields different Variables

#1 (**permalink**) 28-Jul-2006, 08:38 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13547-two-fields-different-variables.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547

Is there a way to do this?

access newb

*

#2 (**permalink**) 28-Jul-2006, 08:38 AM

access newb wrote:
> 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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
> 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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547

--
Joseph Meehan

Dia duit

#3 (**permalink**) 28-Jul-2006, 08:38 AM

Field1 Field2
Joe Hats Hats (auto fill when matched by
keyword)
Tractor Hats Hats
Steel Toe Boots Shoes
Steel Toe Shoes Shoes
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547

This is an Example of what I would be looking for

#4 (**permalink**) 28-Jul-2006, 08:38 AM

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 & "*"

--
Doug Steele, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
http://I.Am/DougSteele
(no e-mails, please!)

"access newb" wrote in message
news:85E906DD-9990-4C73-B938-FD7C659A477C@microsoft.com...
>
>
> Field1 Field2
> Joe Hats Hats (auto fill when matched by
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
> keyword)
> Tractor Hats Hats
> Steel Toe Boots Shoes
> Steel Toe Shoes Shoes
>
> This is an Example of what I would be looking for