View Single Post
  #5  
Old November 14th, 2009, 02:04 AM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Table design help!

Hello Hannah,

Look to see if you have a 1:1 relationship or 1:m relationship. It is rare
to model 1:1 relationships with multiple tables. On the other hand, a 1:m
relationship always requires multiple tables.

Steve



"Hannah" wrote in message
...
I'm a bit of an access novice (training on basics, searching for help on
the
rest) building a database for a research project. I've tried having a wee
look for this question but I can't spot it anywhere (probably because it's
obvious to everyone else).

I'm designing my tables and what to put in them and I've hit on something
I'm not very sure about. For some questions there's a yes or no question
(e.g. "do you eat cheese?) and a follow up if they say yes, theres an "if
yes, which of these types..." follow up question. I'm not sure whether I
need
to structure these into two different tables or whether I can use one
table
for both? I was planning to use tick boxes for these but if there's a
better
way, please let me know! Thanks very much for help in advance - I don't
know
where I'd be without these groups (well I do, somewhere not very good!)