The main objective is to have a "table object" (in Perspective), update automatically to show various data tables (including column names and custom formatting), when selected.
I have been able to update the "data" property using a query binding with a transform, from a solution found online, but I want to update the "column" property "name" element, from the table header as well.
What I have found is that if I manually add the column names from my sample database, the data "content" presents as desired, BUT..., if I have a column binding from the same database, the order of the column property elements appear in the order expected, but the table now displays data which is out of order, or in some other way jumbled.
Manually configuring each column property, does not allow for any flexibility in displaying a different database table, so that is out of the question.
What I also found was that where I only wanted to update the column property, "field:" element, but the binding destroys all other elements that I defined, such as "dateFormat:", where the other properties I would like unchanged.
I had read that a binding destroys all parameter elements, so that's a problem.
I tried to copy all existing property elements in an attempt at using them within the code, to re-insert them into the property, but that seems unnecessarily complicated.
I may be approaching what I had assumed would be a no-brainer, but I would appreciate if I can get some guidance, as I have searched online for a solution for a few days, without any success and need to move forward.
Hopefully I have presented the problem sufficiently to allow someone to provide the needed advice.