I need to have several fields in a record updated as a result of inputting a value. Specifically when I enter a "batch" size I want the number of bottlee, caps etc to change accordingly. I have used a calculated field for this but when I enter subsequent batches of a different size the previous values do not change. I have also attempted to use Auto-enter but although I specified calculated value with'do not replace existing value' checked and unchecked nothing was calculated. In this case the fields remained blank.