I was considering use of a checkbox field to indicate whether a 'patient' had zero, one or more conditions. I will wanting to analyse % of those conditions for a patient group probably in Excel or a stats package. I'm beginning to suspect I'll actually need a related table with a separate field for each condition.
Has anyone used a 'checkbox' style method of indicating condition then gone on to analyze statistically? Advice appreciated.