Ideas? Matching un-matched record names that all mean the same thing.
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