Hi Jeff,
My first reaction is to do this within the same table. If you build your
indexes correctly, performance should not suffer. If you use more than one
table, this still sounds like a job for your database server. It seems
unwieldy to me to have that data travel all the way to a ND server and then
back again. I would suggest a stored procedure in your db server that can
be executed from ND.
If you do decide to do it in ND, I know of no way to do this without Java
coding and do it with one click of the mouse.
my $.02
Roger Feeley
Bridge Information
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Does anyone know if it is possible to take a record out of one
> table and insert it into another table with one click of the mouse
>
> example
> I have a list of records that are all active products, when one becomes
inactive
> I would like to send it to an inactive table for record keeping. I could
do this in the
> same table, but this would bog down the performance of finding active
products,
> which is used often.
>
> P.S. without java if possible.
> thanks all
> jeff
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
