so each row in sql is matched by sequence #.  currently i have my look-up rule that is set up to look like this, however we have notes that can go up to 20-30 lines.  i dont want to keep replicating 30 + rules.  is there an easier method to grab all of the notes and sort it by asc order according to the squence # when using a lookup rule?

If you sequence number is an input of another field, you would use that field variable as your when and have it match the row in SQL.  This way you would not need have a lookup per sequence number.  How is the sequence number being selected on the form?

since i couldn't get anything else to work, i created 10 boxes for sequence and 10 boxes for each line for comments.  so for example, my lookup rule is stated that if there's a call # and sequence 1, then line for notes 1 will appear.  2nd lookup, if theres a call # and sequence 2, then line for notes 2 will appear, etc... i went all the way up to line 10  (all of these boxes are hidden). 

although these sequence/line is for 1 paragraph for completed comments, not sure why the application is built on sequence/lines on each notes. 

i added a main field labeled completed comment (mult-line) box where i've Concatenate each sequence/line in asc order. so when i enter the call number, it'll capture each line by sequence.  the only problem i see here is if there's 30 or more lines.. then i'll have to recreate each line by a lookup rule.  was wondering if there's an easier way using jquery or JS

How should the Call No and Sequence be input into the form?  Is a user putting in a number?  I see you defaulted the Sequence, can these not be entered manually and put in a table to add more than one Call and Sequence?

I couldn't seem to write the correct js code for this.  so the only thing i came with is to aggregate these lines by sequence_no.  I created a set of numbers and a set for fields for the notes.  using a lookup rule, if the lookup rule sees sequence_no 1-10, it'll aggregate all of the notes in sequence_no from 1-10.

So my original inquiry was to see if there's a js method to aggregate these notes into 1 comment in sequence_no ASC without having to create so many fields?

 the example below has about 50 lines for 1 comment. to get it to flow into 1 paragraph, i have to create 50 fields and aggregate them in sequential order.  i have a rule that if there's sequence 1, then fill notes 1, if there's squence_no 2, then it fills notes 2.. etc... these boxes are hidden.  in the completed comment box (visible/not hidden), i have a rule that aggregate all of the lines in sequential order to make it flow like 1 full paragraph.

hope that make sense.

This is what the comment looks like in the application. we want the whole comment to use a lookup rule and transfer into laserfiche forms (in a multiple-line field):

same completed comment, Here's how it looks like using ssms: