HI all, I have an inventory system calculation as follows - Left(SURNAME;5) & DATE & "_" & Right ("00" & Inventory Number ;3) The Inventory Number is a number field with an auto enter calculation - If ( IsEmpty (ARTWORK 2::s_Max_Inventory_Nr) ; 1 ; ARTWORK 2::s_Max_Inventory_Nr +1 ) "S_Max_inventory_nr" is a summary field - maximum of Inventory Number. I'll attach my relationship that makes the system work. Everything runs in order fine.. until a user wants to change the date
