I have two related tables in my database to help track the location of objects.
The main table is the 'inventory' and another is for 'boxes' which includes a unique box number and other information about each box.
In the inventory table the current process is to assign a box number to the object.
The two tables have a relationship set up between inventory::boxNum and boxes::boxNum.
On the box table I have a field set up to track the total objects registered to that box number.
Right now this is calculated through a script that performs a find for the box number in the inventory table and fills the field.
I feel like there has to be a much easier and less clunky way of doing this.
Any suggestions appreciated!