I have the following table that lists the nearest 5 towns for a given starting point. Each [TownFrom] has multiple neighboring towns and a distance to it.
[TownFrom], [TownTo], [Distance]
Miami, Delray Beach,33
and so on...
I am trying to create the following table with all neighors in a single memo field. Note inclusion of the ") - (".
Miami, Palm Beach (11) - Fort Lauderdale (22) - Delray Beach (33)
Before I get the comments about this being bad design I know. The existing table and one I am trying to create are steps on the way to exporting this in a specific format to a static document.
Any input much appreciated.