I created a form in a field where I fetch with select this data: invoice paid, unpaid invoice, use a button to launch a pdf_report, I would like to insert the button with running a query that changes value invoice sent, you can help me write the query sql, thanks.
I like to help, but I can’t figure out what you are trying to do. You want a form with a button that, after clicking on the button, will change the select on a pdf report? If that is the case then you would need to create a control form containing the data and a button that links to your pdf. Using global variables you can use these to postulate the needed sql. Hope this is helpful…