I'm trying to make a form where you can input an existing equipment and module and then input a new existing equipment and module, so for example lets say for the existing input I put Extractor for the equipment and M1 for the module and for the new input I want to put Extractor 2 and module M3. I want it to duplicate all the existing records on the table that have the Extractor as the equipment and the M1 as the module for the new input that I just put (which would be the Extractor 2 and the module M3) and then append the new duplicate records to the table.
I'm making the form based on this table