AnsweredAssumed Answered

repeating fields vs related records

Question asked by brucewilson on Apr 24, 2017
Latest reply on Apr 25, 2017 by beverly

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?