Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2008
    Posts
    8

    Unanswered: I need help in setting up an Intranet Search Engine for my database

    hello everyone and this is my first post in the forums after looking around a bit.. This is my current situation:

    I was tasked to create a search engine for a database of electrical components.. the database is made up of 10 tables which comprises the different electronic component(capacitors,resistors,etc ect) under each table ae the different models with their corresponding properties which uses up 20+ columns..

    I'm completely new in MS Acess and this is my first time to setup a search engine.. I am completely clueless on how to implement this and i am hoping that somebody could help me out..

    Finally, the search results should display all the columns for that specific item.. thanks in advance and mor power

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    the database is made up of 10 tables which comprises the different electronic component(capacitors,resistors,etc ect)
    10 tables to store electrical components?? Why? I'd be having a look at the table structure for design flaws.

    If the components were in ONE table, your search "engine" would be dead simple... and tbh, there is no reason they couldn't be in one table. Searching multiple tables is going to be quite complex by comparison.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Apr 2008
    Posts
    8
    I was not the one who designed the table.. what happened here is that they sorted out the components into different tables

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well just for the record, that was a silly thing to do.

    Can you post up your table structure? And what fields you want to be able to search in this search engine?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Apr 2008
    Posts
    8
    i am prohibited from posting the actual pictures here so ill just explain it in the clearest manner possible..

    The database is made up of ten tables of electronic components.. All the ten tables have the same number of columns with the same headings(titles)..

    It is required that i show all of the columns during the search results;

    it is something similar to the search function found at digikey.com

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    best thing to do
    merge the 10 tables into one.. thats waht Digikey, RS CPC, Farnell will be doing
    identify the comonent type before you do that (with a new table called say 'ComponentType')
    allow you users to specify what component type they want.. and take it from there

    otherwise you have 10 different SQL's for each action

    well if you can't mask the table design to give enough idea of what you want to do, I suspect there is little we can do to help

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Should be pretty easy to create a union query to merge all the data together into one object and then you could build your search engine on that.

    Pretty hard to say much when you can't even post a picture of your table structure
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Apr 2008
    Posts
    8
    ok here are some of the tables:

    Capacitors
    Capacitors Vishay
    Connectors
    Diodes
    ICs

    And they all have the same fields

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    create a union query to merge all the data together into one object and then you could build your search engine on that
    I agree with this ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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