Combining grouped text fields

[Chalkster]

I have a database that lists airline routings for query by an internet booking engine.

These take the form of various tokens of info listed in a string.

I have created a database with tables for calculating each part of the routing string. Because a single routing can hold up to 40 possible segments and it takes approx 30 including calculated fields fields to hold the data for each segment the solution I used was to list segments in one table grouped by ID (thus giving me a table of 30 fields instead of 1200).

The tokens are combined in one single field in a related table for output to the booking engine and it is the combining of groups of these segment tokens that is giving me the headache

Each grouping within the table can be of anything from 1-40 records with a common ID.

Eg as a simple example if I had seven records in the table "segments" grouped with airline code BA and each record produces a different result in the calculated field how can I create a text string of all seven different values with no punctuation between them (order of values does not matter) to be entered in the table "routing strings" in a single field?

Any ideas would be appreciated immensely

[RalphL]

I would use the Troi Text plug-in. http://www.troi.com

You can download a trail version to experiment with.