OK

Dont even know if this is possible but here goes. I have got a variety of fields that are from a value list. I am wanting to have a second field which can determine the range that these value lists go for, for the chosen set of records.

The value list is this

ES1 Early

ES1 Mid

ES1 Late

S1 Early

S1 Mid

etc etc..... you get the idea(there are 16 of those altogether)

I need a field that will say that these records go from ES1 Mid to S1 Late (or whatever) this will then go to a relational database to put in an appropriate picture for a report card.

Hope I've made sense and any help would be greatly appreciated.

Many thanx in advance

Poida

If I understand your Australian English: You have a field (populated by a choice from a value list) which contains ES1 Early or ES1 Mid, etc. For a particular Found Set, you want the range of values in that field to go into a second field which will then relate to a record in a second file.

Sort the records by that field. Then, in a script, Go to First Record. Set the value of that field into a global. Then, Go to Last Record. Set the value of that field into a second global. Then you can concatenate the two globals (perhaps with a " to " in-between)and post that value to a field in a selected record in the second file.