I want to have an auto-enter field or a calculation field that serializes records by category. i have attached a sample of the database I have. I have four fields (Group, Name, Serial Id, and Max Serial Id). I have 1 table with 2 ocurrences. The field 'Max Serial Id' is based on a relationship from an occurrence of the main table that uses the max() function to show the largest 'Serial Id' value entered for a particular Name under a Group. I want to be able to auto enter the Serial Id number every time a record is created. The calculation should look into the Max Serial Id field and get the value and then add a 1 to the Seria Id value.