1 Reply Latest reply on Aug 22, 2012 7:15 AM by erolst

    related table counts

    erickaczmarczyk

      Hi:

       

      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!

       

      thanks!