Please give me some advise on my database design. It's basically an audit sheet that users will record their findings after doing an audit. There is a around 50 different issues being audited between 4 different areas (eg-are workers wearing their saftey glasses?, floor free of trash?). I want to list all issues, and users will check YES/NO. Should I use one table for the issues, or 4 tables broken down into sections. Also, If the decision is NO, then I would like there to be a comment, status, and how many memo box. Should I use a ton of IF/Then statements for each YES/NO decision to make a text box appear? I had basically designed this a while ago quite differently; I had each decision a record. Now they would like each audit to be a record.

Thanks for reading all of this.....Please advise....Any incite would be appreciate.

Depends if this is a data entry or reporting issue.
Reporting then does not really matter how many "issues" you have, you could report them on a page.
Data Entry, that is another story. A form with 50 check boxes would be rather busy. If you could catergerize them and put them on different tabs or something, that might be a better solution. For your Issue remarks, when NO is checked, why not use a popup to record the comments, put the popups in a seperate table and use a foreign key to tie them back to the original form.
Just some of my thoughts.