Newbie question please help

[Napier]

Hi All,

I am hoping you can help me, for work I want to create a database.

Scope:



There are multiple documents in circulation with lots of different questions. Some documents have the same question but sometimes multiple replies. The questions and answers I want to all pull into one database for ease of search rather than run around trying to find the document xyz. This will also ensure one central repository, mean we can trust the answers from one source and keep one source updated.

How easy would this be to create?
How easy would it be to manage do you think?

Any neat ideas, tips or tricks you think would be good here?

I am good on computers and have a networking background, used MS Access a long time ago so my memory on this application is not fresh :-(

Your help and guidance would be really appreciated!

[Robeen]

From what you describe, this should be pretty simple to design.

I think two tables would do the trick:

Table1 - 2 fields:
QuestionID, Question.

Table2 - 2 fields:
QuestionID, Answer.

In Table1 each question would only appear once and have a unique ID.
In Table2 each QuestionID might appear more than once - each time with a different answer.

Hope this helps!