Summation of text with serial numbering

[Dr.Hamed]

I have a textbook composed of chapters. The book was simply entered as separate sentences in text field, and chapter titles in another text field.

 

Chapter Title                  Sentence

ABC                                     aaba

ABC                                     abac

ABC                                     efgdf

ABB                                     bdc

ABB                                     cdfegdf

.

.

.

 

What I would like is that when I search for a chapter title, to have the result of sentences summed up in a field and separated by serial numbers starting from 1

 

For example: Searching the above data for the title:

 

ABC should show the output in a field as:    aaba (1) abac (2) efgdf (3)

 

Of course chapters have variable numbers of sentences, so the count has to stop with the last sentence.

 

I really appreciate your help.

[comment]

If you sort your records by chapter, you can use a summary field to number the sentences in each chapter like this:

 

ABC
1    aaba
2    abac
3    efgdf
ABB
1    bdc
2    cdfegdf

 

 

Getting the result into a single field like in your example would be more difficult - and I am not sure what purpose it would serve.

[Dr.Hamed]

The textbook is the bible, and the sentences are the verses. I have the verses in separate records for searching exact location..

 

The purpose of the output as such is to read the chapter in a formal way, with numbered verses.

[comment]

Well, you could try it this way:

 

ChapterReader.fp7.zip

 

 

Note that properly you should have a separate table of Chapters (and, I guess, another one for Books).

[Dr.Hamed]

Dear Comment,

 

As it used to be, you always have a solution; and to be more precise, the best solution

 

THANKS