View Single Post
  #1  
Old November 13th, 2009, 12:24 PM posted to microsoft.public.access.tablesdbdesign
hannah
external usenet poster
 
Posts: 66
Default Table design help!

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!)