Jump to content
Sign in to follow this  
William Mead

Move record(s) from one table to another

Recommended Posts

Hi, is there an effective way of moving a record (or set of records) from one table to another?

Here is the situation. I have a database of exhibitors, some are active and some are inactive. On a day to day basis, I want to deal only with the active ones. Rarely do I need info about inactive exhibitors. Currently I have a radio button flag marking them as active or inactive, but every time I search for a group I have to remember to click the active flag too. I would much rather have a button that just moves an exhibitor to the inactive table and takes him out of my active one. Does that make sense? Do other people run into this minor annoyance and what is the best way to solve it?

Share this post


Link to post
Share on other sites

Why not just script the find to only show active members? Sometimes it's nice to keep the data in one table just for historical purposes.

If you really need to move them you could just script the find to show the "Inactive" members and then fire a script that imports them to the other table then deletes the found set in the original table.

Michael

Share this post


Link to post
Share on other sites

Which script steps would you use to do this? Do you have to do it field by field? Or can you simply do some sort of copy/paste of the record from the old table to the new?...if so, how? =)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.