Why do newly created elements within a group that is linked to joined list always get inserted in the left joined table and not the outer table? What dictates which table the field gets created?
===steps====
1. create two lists, "table1" and "table2"
2. inner join them called "joinList1"
3. create a group "group1" and assign it to "joinList1".
4. create an element "first_name" and assign it to "group1"
5. notice it will create the "first_name" field in "table1". Why not in "table2" ?
- Lets say I had originally a "first_name" field in "table2" and ran the above steps. "table1" and" table2" both have "first_name."
How do you dictate which table new elements get created in joined lists?
I'm trying to group up lot of fields to make use of the tabs in the fabrik forms. But since my list is based on a join any parent element I reassign to the new group(s) will error out (sql error) which i think is per design. So then I'll start from scratch and create a new element and assign to to one of the new groups, however as in the steps above it the element always gets created in "table1" the left table of the join instead of getting created in table2. How do you group element in "table2" I only see grouping based on join unless it s stand alone non joined list based on one table; then you can create groups and move elements around because there is no second table.
Hope I'm making sense.
thanks
===steps====
1. create two lists, "table1" and "table2"
2. inner join them called "joinList1"
3. create a group "group1" and assign it to "joinList1".
4. create an element "first_name" and assign it to "group1"
5. notice it will create the "first_name" field in "table1". Why not in "table2" ?
- Lets say I had originally a "first_name" field in "table2" and ran the above steps. "table1" and" table2" both have "first_name."
How do you dictate which table new elements get created in joined lists?
I'm trying to group up lot of fields to make use of the tabs in the fabrik forms. But since my list is based on a join any parent element I reassign to the new group(s) will error out (sql error) which i think is per design. So then I'll start from scratch and create a new element and assign to to one of the new groups, however as in the steps above it the element always gets created in "table1" the left table of the join instead of getting created in table2. How do you group element in "table2" I only see grouping based on join unless it s stand alone non joined list based on one table; then you can create groups and move elements around because there is no second table.
Hope I'm making sense.
thanks