Force Unique Address
I'm wondering how to force a database to only allow unique addresses? I have a database and when addresses are added, I want to make sure that the addresses isn't already in the database and if it is...
Forum Discussion
For some reason, an address field type does not have the attribute to enforce unique.
But i think that you can make a text string that looks like an address and force it to be unique
List("\n",
[Address: Street 1],
[Address: Street 2],
List(" ", List(", ",[Address: City],[Address: State/Region]), [Address: Postal Code]))
But i think that you can make a text string that looks like an address and force it to be unique
List("\n",
[Address: Street 1],
[Address: Street 2],
List(" ", List(", ",[Address: City],[Address: State/Region]), [Address: Postal Code]))
