If you add a field to flag cancelled records use an append query to copy the
flagged trades to another table and if wanted a delete query to delete the
flagged ones in your source table.
Why? As in "why move the records around?" You already have a lead to a
solution in the other response to your question.
Add a "flag" field to indicate that a record is cancelled, then modify your
queries to exclude "cancelled" records. All the data stays in place, and
you can, if you need to, easily look up ALL records without having to look
in more than one table.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
