I'm in charge of a database that contains property information. I would like to symbolize parcels of land that we have a 'written agreement' with the owner differently than parcels that we do not have written agreements with.
My solution was to create a calculated field (1 or 0) based on if there was any data in the "Agreements" field.
I'm looking for a more dynamic solution (not having to re-run the field calculation) so that when an agreement is entered into the db, the symbology automatically changes.
This is important because our field staff take the db out into the field on hand-held devices; they need to know which properties they are allowed to access (green) vs. which properties they cannot access (red).