i have repeated rows that i want to insert into a new table but the insert record can't do that. please can anyone help me with that
You need to do this manually. Are the users interacting with this rows, or are they just getting inserted from one recordset into another table?
they are inserting from one recordset to another
If there is no interaction, then just use the INSERT INTO SELECT syntax to insert rows from one table into another.
the issue is just like inserting for example. texfield1, texfield2,texfield3 into the same field at the same time.