Ecovoyageurs
Member
Hello,
In many cases, where we have to organize datas with parent > children approach, we can use both list joins or just repeating groups.
If I understand well, list joins creates a real different table whereas repeating groups creates a "kind of" children table (with ids linked to main table).
Please correct me if I'm wrong : list join seems more appropriate when we need to edit each child row independently whereas with simple repeating group we have only one form to edit at the same time parent and children datas.
Is there a difference for optimization and queries ?
Any other important difference I forgot ?
Thanks
In many cases, where we have to organize datas with parent > children approach, we can use both list joins or just repeating groups.
If I understand well, list joins creates a real different table whereas repeating groups creates a "kind of" children table (with ids linked to main table).
Please correct me if I'm wrong : list join seems more appropriate when we need to edit each child row independently whereas with simple repeating group we have only one form to edit at the same time parent and children datas.
Is there a difference for optimization and queries ?
Any other important difference I forgot ?
Thanks