Remove value from value list if already used?
I have a value list for address types: Main, Billing, Shipping and Install. The field is called "AddressType" and is in the Address Table.
While a sales rep is in the Customer Table layout, they can add new addresses in a portal and give it a value from the above list. I need a calculation that only lets "Main" be assigned to one address per customer. The other values can be used as many times as needed. So, once Main has been assigned the value list will no longer show it as a choice in the drop down value list. I hope this makes sense.