Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Two fields different Variables

Discussion in 'Information Technology' started by access newb, Jul 28, 2006.

  1. access newb

    access newb
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    US Defense Department Hiring Resident Aliens in Medical and Language Fields Business, Lifestyle & Leisure Dec 6, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (New Kerala) Breaking News Apr 1, 2008
    Sikh News Women more vulnerable to cancer in Punjab's cotton fields (Calcutta News) Breaking News Apr 1, 2008
    Sikh News Punjab's killing fields (The Times of India) Breaking News Feb 24, 2008
    Sikh News MQM fields 218 candidates in Punjab (The Pakistan Link) Breaking News Feb 1, 2008

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    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,
    > 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"

    --
    Joseph Meehan

    Dia duit
     
  4. access newb

    access newb
    Expand Collapse
    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
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    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
    http://I.Am/DougSteele
    (no e-mails, please!)


    "access newb" <accessnewb@discussions.microsoft.com> wrote in message
    news:85E906DD-9990-4C73-B938-FD7C659A477C@microsoft.com...
    >
    >
    > 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
     

Share This Page