Is there a quick way to copy a complete row of data (by using the row ID) into a new row so it is given a new ID.
I can't think of any other way than, copying all of the data into variables and then inserting it back into the DB.
What I need is an exact copy but just different ID numbers.
BTW, I can't just CHANGE the ID numbers as they are generated automaticaly every time a new entry is entered into the DB.
Any Ideas ???