I have a medical database and have been asked to add a symptom checklist.
There are 30 symptoms phrased as questions, each needs a yes/no checkbox and Details text field.
The immediate thought is a related table with these 3 fields plus primarykey.
I would also have another table (with 30 records) for the list of symptoms.
But how do I show the 30 questions on a form? Doctors need to be able to scan down the list.
Option 1: A portal on the form, has to be populated with 30 lines of symptoms when a record is created.
This creates many related records that will not be used, the file size increase is significant but probably acceptable.
Option 2: Show 90 individual related fields, from 60 relationships!
Option 3: Show 60 individual fields plus 30 text descriptions from the base table.
What am I missing?