Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
7 years ago

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, I want that one picked.  How can I do this?

Thanks,
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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]))