View Single Post
  #3  
Old November 13th, 2009, 08:06 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default Table design help!

Hello Hanna,

I noticed that nobody answered.

To be honest, your post indicates confustion on even the fundamentals, and a
responding would be even tougher than starting at zero because they would
have to start by undoing you wanting to talk about the cart before the horse,
as your post seeks to do. And you've given zero informaiton about the horse
leaving nowhere to start.

Well, if you survived that paragraph, you need to start by defining for us
(if not for yourself) the nature of the real-world process that you want to
databse, and decide and determine what the "entities" aree that you want to
database.

I'm guessing that one of these entities will be "questions" beyond that
you gave us nothin' to go on.

- Maybe your entities include people (who are taking the survey)

- Depending on what the nature of potential answers are (just yes/no?
Multiple choice from a set list? Free-form writing in the blank? anoth
entity might be potential (allowable) answers on multiple choice questions

- Maybe your entities include surveys (which are groups of questions) if
there are multiple surveys

- Maybe your entities include instancs of answers to questions

You'll have to tell us.


The answer to your "if-then" question will be dependent on your structure,
which you are going to build upon your "entities" answer. Also on you
defining whether or not a particular answer leads to just one "next
question" vs. a group of them.


I know that that makes your "next step" pretty complicated right now, but I
think that such is inevitable, and hopefully this helped a bit.