AnsweredAssumed Answered

Sum of different Part #’s

Question asked by MattW_1 on Feb 5, 2016
Latest reply on Feb 6, 2016 by MattW_1

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.

 

Thanks!

Outcomes