Adding

[Guest]

At times we have requisitions that are incomplete. These are updated through
a query. If the order calls for 10 and 5 are received the next day the
remainder has been received it overwrites the first amount and the record
only shows 5 even though 10 has been received. What is the best way to
correct this?

 

[Wayne Morgan]

Create a second table to store the actions that are complete. Link it to the
current table on the ID field for the records in the current table. As each
part of an item is completed it will then create its own record in the new
table. To see if an item has been fully completed, you would add up the
items in the new table where the link field matches the ID field of the
current table and compare that sum to the requested number in the current
table.