Kent Searight Posted January 21, 2005 Share Posted January 21, 2005 I'm trying to figure out a way of creating an auto-enter-by-calculation text field that will do the following: Auto-enter one of three different values in a field, using the following criteria: If no records in a set contain the text "Current Use", then "Current Use", will be the auto-entry. If there is already a record containing that value, then I'd like the next new record to auto enter "Transfer of Ownership" into the field unless a record in the set already has that value. And then, if there are already records in the set that contain those values but they don't contain a 3rd value "Building Permit", then "Building Permit" is the next value. Now if all 3 values exist in a set of records, auto-enter will be a blank. But, if any of the values are deleted from a set, the calculation will automatically enter the missing value(s). Any help is humbly appreciated Link to comment Share on other sites More sharing options...
This topic is 6635 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now