Scenario:

laserfiche Forms - Have 3 tables: Table A, Table B, and Table C

Table A, B { are the same fields under a different table Name }
Table C { have some of the containing fields from Table A and Table B }

Fields in Table A,B Are : Date {Date Field} ; Invoice Number {Single Line Field} ; Amount {Number Field}

Fields in Table C Are : Date {Date Field} ;Voucher {Single Line Field}; Invoice {Single Line Field} ;Approved {Single Line Field};Matched on Statement {Single Field} ; Amount {Number Field}

I am looking at a basic script or way of solving the Following:

When fields Date; Invoice Number; Amount is in both the Tables A & B and they are the same, to remove them from Table A & B and insert the Values into Table C.

If someone could guide me in this it would be much appreciated.

Thanks