Discussions

Expand all | Collapse all

Force Unique Address

  • 1.  Force Unique Address

    Posted 08-22-2018 14:02
    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,


  • 2.  RE: Force Unique Address

    Posted 08-22-2018 14:21
    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]))


  • 3.  RE: Force Unique Address

    Posted 08-22-2018 14:40

    Okay, thank you.