I have a file that contains one word in each record, how can I create a field that shows two consecutive words "records":

Record1: They

Record2: went

Record3: to

Record4: school

I want a field to show in record1: They went

In record2: went to

In record3: to school

In record4: school 

Thanks

The problem with your question is how to define "consecutive". If it means consecutive within the current found set and sort order, then you can use the GetNthRecord() function to get the value from the previous/next record - say something like:

Yourfield & " " & GetNthRecord ( Yourfield ; Get ( RecordNumber ) + 1 )

If you're looking for a permanent order that does not depend on the current found set and sort order, then you will need to construct a relationship whereby each record is related to the previous/next record - for example, by adding 1 to a serial number and using it to match the next record.

 

I'm looking for a permanent order, I will try the relationship.  Thanks so much.