I have a db that has fields called CaseYear, Case#, Supp#, NarSeq#, and Text. I want to search the db where asprunner will return all text fields for the same caseyear, case# and supp#. The problem is that the text lines are numbered from 1 to ???? in the narseq# and there is one line of text per narseq#.
a data line looks like this:
CaseYear Case # Supp# NarSeq# Text
09 123 1 1 This is the first line of text
09 123 1 2 This is the second line of text
09 123 1 3 This is the third line of text
09 123 1 etc
ASPRunner returns thus:
09
123
1
1
This is the first line of text
09
123
1
2
This is the second line of text
etc.
I need to search and it return
09-123 1
This is the first line of text
This is the second line of text
This is the third line of text
Thanks, Joe