9 Replies Latest reply on Apr 25, 2017 4:42 AM by beverly

    repeating fields vs related records

    brucewilson

      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?