3 Replies Latest reply on Feb 25, 2016 1:19 PM by DavidJondreau

    Repeating Fields and their usefullness

    andrewma

      So i have heard a few times that most people consider using repeating fields for data storage to be a bad idea for most cases.

       

      I have one question to determine if repeating fields are bad for "ME".

       

      For simplicity sake lets say I have a database with 5000 records. Each record has just one field.  This field has 20 repeating reps.

      There is unique and different data in each rep.

       

       

       

      Today if i do a find i can choose any rep and type my find request and it will find the record i want. (the data i'm looking for could be on any random rep)

       

      If I were to change the one repeating field of 20 reps to 20 separate fields with one rep each, I would have to know which exact field the data is in to do the find.

       

       

      Am i missing something ?