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
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.
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