AnsweredAssumed Answered

Ideas? Matching un-matched record names that all mean the same thing.

Question asked by craig5005 on Sep 28, 2013
Latest reply on Sep 30, 2013 by philmodjunk

Title

Ideas? Matching un-matched record names that all mean the same thing.

Post

     Bad title I know.

     I've been thinking about this problem for the past hour or so, can't figure out a way to solve it.

     Users can manually enter a location where they are collecting data (example Room A).  However sometimes they enter it as Room A, roomA, aRoom, Room #A, RmA... the possibilities are endless really and I can't get around the manual entry.  So I need a way to merge these to all match.

      

     I want to be able to display all the locations through a checkbox populated by a value list of all the locations.  The user would select all the locations that are the same (room A = RmA = RoomA) and then choose one of the them populate all the location fields so they all match.  Any idea how this could be achieved?

      

     FMA11 Mac os x 10.6

Outcomes