Moving records

[JeRz]

Hi everyone,



newbie to the forums. This site has helped me out so much this far.

if I have 2 tables one being 'open issues' and the other being 'closed issues' is there a way so that when I update the 'status' field, for example, to 'closed', that it would automatically move the issue from the open issues table to the closed table?

Any help would be greatly appreciated! Thanks!

[cbende2]

Yep! you can create an append query that runs on the "Open issue" table, and have it append all records that have the "status" field set to "closed" to the "Closed Issues" table. After that, you will need to create a delete query that also runs on the "Open issue" table which will then delete the records that were just appended to the "Closed Issues" table.

Set these two macros in the Afterupdate property of the "Status" field.

Also if you'd like, you can attach your DB and I can look at it and maybe create it for you or just lead you in the right direction.