I have a query (query1) that is triggered when a drop down is selected in my table (table9). That query gathers the table row (0) and value (J2-5) needed for insertion into a column (PinCavity) within the same table (table9).
I know that changesetArray/changesetObject are read only arrays.
I've read all the postings on the forum but I haven't found anything that was concise on how to insert data into a table cell within a query.
So to recap, I have a query (query1), a table (table9) that I need to insert data (J2-5) at row 0, column PinCavity, how would that happen?
Any help would be greatly appreciated. Thank you