move all data as status Completed into another table

[akika]

hi,

In my form i have a field drop-down status with values (WIP, On-Hold, Completed)

i want that once the status for a task is set to Completed. Alll the details for that task is moved to another table.

how can i do that?

 

[theDBguy]

Hi. Why would you want to do this? Just curious...

 

[jdraw]

Can I ask why you would move them? They are easily identifiable with a query.

I see DBGuy is 10 minutes quicker......

 

[Dreamweaver]

I would just create a field in the table called say status 1=Active, 2 =Complete and so on then you can create queries to display data depending on the status should you wish.


hope if helps mich