AnsweredAssumed Answered

Repeating field or separate fields for rehoming information

Question asked by user27358 on May 27, 2016
Latest reply on May 27, 2016 by electon

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.