I work in a high volume ecommerce sales business where we process items that are grouped together in boxes. Each item has a unique ID number, and the box that they are in also has a number. Each item is entered into our database including the item's ID number. But if we wanted to include the box number along w/ the data for each item, we'd have to input the box number for every entry. I know I can set up a box number field to maintain its value until it is changed by the user but that's not practical since it would be too easy to forget to update. I want to create a simple form that we would fill out when a box is created that would just contain the box number, the first ID and the last ID, and have a Box number field in the item inventory form auto-populate based on the data in the Box data form. So, when an item's ID number falls within a certain range of a given box number, that boxes number is auto filled into the item's inventory record. Any ideas?