Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Searching a table for a value (Access97)

    I have a small table of 320 records with 10 columns. Its a product cross reference table.
    Using code I want the user to be able to type a value in a textbox and have the db return the row that the value appears in.
    The value won't necessarily be a primary key or an ID field, it could be any field in any one of the columns.
    I'm not sure the best way to go about this.
    Open to all suggestions
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Searching a table for a value (Access97)

    Sorry, but I'm having trouble envisioning this table. Does it by chance have a field structure like Prod1, Prod2, Prod3, etc? What exactly do you mean by a product cross reference table?
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Searching a table for a value (Access97)

    Hi,
    The column names are different manufacturing companies
    the rows are their model numbers for the item
    Each company has its own model number even though the item is the same
    eg. sorry doesn't format properly
    company1 company2 company3 company4
    tl32c ft2343 2345 widget1
    rd4565 pp1221 rr45 344r
    I want to be able to lookup say "widget1" and have the db return that whole row so the user
    can see what the equivilent models are
    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •