related table counts

Discussion created by erickaczmarczyk on Aug 22, 2012
Latest reply on Aug 22, 2012 by erolst



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!