2 Replies Latest reply on Feb 6, 2016 4:25 AM by MattW_1

    Sum of different Part #’s


      I have a single table with multiple duplicate part numbers that get entered throughout the day.


      I’m trying to figure out the best way to have a field that shows the running total of all quantities for that one specific item so the user knows if they’re going over the allotment for that day, as they type in an existing part #.


      Fields we have are “Part #” and “Quantity”


      So a user types in Part # 12345. I’d like a field to show

      The running quantity total of that item above where the user is putting in the

      Current total of that same item.