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.