Hello Rick, In my database, the "order" is the parts and costs used in repairing a transmission, if the unit comes back for a warranty or something, we may have to add more parts into the order to keep the cost correct. I don't want to add one part and have it take out the first 20 again. Is there a way to tell it to ignore the ones that are already submitted?
My current thinking is maybe I could add like a checkbox to the joint table and after they push the button it marks all of them, and then not count them the second time through?
If so, would that be something like While Not rs.EOF and AlreadyRanCheck = False ChangeInventory etc.?
Thank you for taking the time. Database goes live in about 2 weeks and I'm super stoked to see how it improves the workflow.
Yes, that is exactly what I would do. Add a field to determine whether or not a part has already been removed from inventory and then don't process that one again.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 326.
