I have parcels with different landuse classes: Business, Residential, etc. I would like to generate a unique id when the parcel is being split. However, I need to generate a different id and counter depending on the landuse class. If Business, then generate B1, B2, B3, etc. If Residential, then generate R1, R2, R3, etc.
This is my progress.
|Table Name||Field Name||Value Method||Value Info||On Create|
|Parcel||PLOT_ID||EXPRESSION||IIf([TYPE]="Business","B" & [PLOT_ID],"")||TRUE|
|Parcel||PLOT_ID||EXPRESSION||IIf([TYPE]="Residential","R" & [PLOT_ID],"")||TRUE|
I could not figure out how to trigger it. Any help would be appreciated.