Has anyone created a script or know how we could "move" a record from one table to a next?
Part A is in a table called "Prototype", Once we've determined it can be released we want to "move" it to component A in the table "Diodes"
It can't be a copy or a cut and paste because its oracle data and the part number already exists and cannot be replicated.
It's a literal move
Library manager doesn't allow "cut and paste" into the the ODBC table views from one table to another