I have a detail finance data in a table. I added a checkbox and combobox that link to invoice ID table, when the user select invoiceID from the combobox and ceck the checkbox, I want a copy of this record to go to the invoice detail table with the right invoiceID.
First table where the deytails are: called Detailfinance_tbl and copy of the record should go to table called invoicedetail table.
The fields that should be copied after selecting the invoiceId and clicking on the checkbox is is Amount,InvoiceID, and description
Is there a way to do this?