Question from @edmartin
I was hoping to ask your thoughts on a process I am trying to refactor. My current order form has two main tables to which it writes data in MySQL; orderHeader and orderDetail. The first is the Customer contact and billing data, the second is the table that lists all of the products being sold and their pricing and other delivery data.
In my first app, I had the user select the customer and then the customer data was queried into a table and represented onscreen by a linked form. There is a component that is linked to a query that retrieves the next is number from the orderHeader table because this is the foreign ket to the orderDetail table.
While the orderHead form is open, the form that allows the user to select products and insert them into the orderDetail table in MySQL is used to "build" the order. My issue is with the fact thay I can run an insert query from the retool page, but if I call the insert query from a button it will not execute.