Pivot Column Reorder
Hi everyone,
I'm working with two tables, "Locations" and "Waypoints," that are connected through a pivot table called "location_waypoint." The pivot table includes an additional column called "sort_order." I'm looking for guidance on how to display and reorder the 'sort_order' pivot column within the "Locations" table.
(1) Retrieve the 'sort_order' column from the "location_waypoint" pivot table and show it into the "Locations" table.
(2) Reorder the 'sort_order' column and after reordering it should persist in pivot table.
Any assistance or suggestions on achieving this would be greatly appreciated. Thank you in advance for your help!
I'm working with two tables, "Locations" and "Waypoints," that are connected through a pivot table called "location_waypoint." The pivot table includes an additional column called "sort_order." I'm looking for guidance on how to display and reorder the 'sort_order' pivot column within the "Locations" table.
(1) Retrieve the 'sort_order' column from the "location_waypoint" pivot table and show it into the "Locations" table.
(2) Reorder the 'sort_order' column and after reordering it should persist in pivot table.
Any assistance or suggestions on achieving this would be greatly appreciated. Thank you in advance for your help!
