31

The way I understand it is the optimal direction of linking depends on the nature of the data, how you need to search it, and how you need to display it. This could call for linking data one way, the other way, or both ways (or neither, using an intersection table, which can be a bit of a nightmare, but let’s not go down that rabbit hole…).

So for example if we have an app with dog owners (“Owners”) and dogs (“Dogs”), if the Owners were regular people, they may only have a few Dogs. And if you wanted to show RGs of Owners and their Dogs, then having Dogs within a list field for each Owner would make sense. That way the RG doesn’t have to do a “do a search for” for each Owner in order to show the Dogs in each RG’s cell.

But if that app was a directory of dog breeders, and each Owner has thousands of Dogs, then the approach changes. App users would be searching the Owners datatype (ie breeders) based on things like location, pricing, dog types, years in business, etc. The RG of results would list the Owners, but would not include the Dogs of each Owner (Dogs would only be listed in a details panel for a specific Owner). If each Owner record had thousands of Dogs attached to it within a list field, then the Owner records becomes very data heavy, which slows down the search and display process. And because there is no need to list an Owner’s Dogs within the results RG, there isn’t any speed benefit from having those dogs in a list field in the Owner record.