May 24 2012, 01:30 PM
This might be in the wrong forum
I am looking to create an information FAQ database something like you see on 911 tv shows where the user types in some information and gets all related articles, etc, pertaining to those words
Any ideas would be most appreciated
May 24 2012, 01:33 PM
I think there might be some demos in the Code Archive that could give you an idea on how to create something like that.
For example, here
Just my 2 cents...
May 24 2012, 02:28 PM
I think you need a minimum of seven tables, one for the subjects to search, one for the possible "answers" to subjects, and a junction table in which to link possible answers to questions. Also, you'll need a table of keywords on which to search and a junction table to link possible questions to the keywords you can use to search for them. Then you will need a table of links to references and a junction table to link possible answers to references.
The question table needs at least two fields. One will be the "subject" of a search. e.g. "How many pies does it take to make a person fat?" The other will be the Primary Key.
The answer table needs at least two fields. One will be the "possible answer", e.g. "Twelve apple", or "Fourteen Lemon meringue." The other will be the Primary Key.
The reference table will need at least two fields. One will be the link to the selected reference. The other will be the Primary Key.
The Keyword table needs at least two fields. One will be the "Key word". The other will be the Primary Key.
For the three junction tables, you'll combine a Foreign Key from each of the two linked tables.
Beyond that, you may add additional features that will require additional tables or fields, but that ought to get you started.
May 24 2012, 03:05 PM
You might want to dig into the downloadable Access Web file
, which replicates the entire website in a database environment, including a search function.
Hope this helps,