Hi folks, Im building a database for my business and have gotten stumped trying to make an inventory number that would increase numerically - but only relative to other records with a common field. Here’s an example: Currently we manually generate an...