13 Replies Latest reply on May 27, 2016 2:58 PM by electon

    Repeating field or separate fields for rehoming information


      We re-home birds. There are often several fosters and adopters connected to the same bird.  This information, by date, is tracked over many years as birds can live many decades.


      The foster/adopters are kept in a People Table. The birds are kept in a Bird Table. 


      Is it better to use a repeating field for fosters, and a repeating field for adopters?  Or is it better to create separate fields for Foster 1, Foster 2, Foster 3, Adopter 1, Adopter 2, Adopter 3 ... fields.