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, I want that one picked. How can I do this?
Thanks,
Question
Force Unique Address
+12For 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]))
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.