1 Reply Latest reply on Apr 17, 2012 3:16 AM by Sorbsbuster

    assigning two values to a single field

    JamesPickett

      Title

      assigning two values to a single field

      Post

      I have a table for geographic locations; 99% of time a given location only has a single name, but every once in a while it has two or three names or is subject to alternate spellings, etc.  Is there way for me to selectively give a field two values, i.e. a kind of "or" operator such that the same instance would come up if I searched on any of the names?  A join table or a check box solution does not really seem appropriate for this challenge.