Hi,



I'm pretty new to Database design and I was hoping someone could help. Part of my new database consists of about 100 Y/N questions that can pertain to each unique "person" record. I will put all these question on one form with many tabs to separate the different types of questions.

I tried making a separate table for each category of questions, with the questions being the column title and each row being the person ID# and the fields being Y or N.
I connected the two person ID#'s (from the person table to each question table) as a one-to one relationship. Is this the best way to go?

Thanks,
Daniel