Moving from one table to another table

[Ads]

Hello

I have to move records from one table to another.

When we lose a client I need to take them out of my current table and put them in my dropped table.

I don't want to lose my summary info and I want the dropped client to keep it's ID Number which is an identifier.

Seems I can't just copy it from one table to another and then go back and delete it from the Current.

Seems I can't cut from Current and paste into Dropped.

In a perfect world it would be great if my boss could just check a box in Current Table and the record moved to Dropped all by itself!

 

[bob fitz]

Why not just add a checkbox type field to the first table, perhaps called Dropped, which can be ticked from within a form when a client is dropped.

 

[pbaldy]

+1 for leaving it in one table and having a "status" or "dropped" field.

 

[Ads]

Why not just add a checkbox type field to the first table, perhaps called Dropped, which can be ticked from within a form when a client is dropped.

Although it would seem that would be acceptable, I have to remove the dropped info from the Current Table as it is no longer current and the people using the current table all day don't want to see the dropped clients in the current file.

 

[Ads]

+1 for leaving it in one table and having a "status" or "dropped" field.

Sorry, not understanding this?

 

[pr2-eugin]

Paul just recommends or agrees that it should not be deleted but just change the status. If you change your Query to show only the "Current", then the dropped will not find its way into any FORMS or Queries.

 

[Ads]

Thanks everyone

 

[scubadiver007]

All you need to do is include the checkbox in the table and base the form on a filtered query so when the box is ticked on the form, the record then no longer appears.

If you wish you can also have a duplicate form for the reverse so at least you can view the dropped records without going into the table.