illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)

I have been looking at the issue of child tables when used within say invoice/order/quote body.

I have parent table (Quotes) and child table (QuoteLines)

Each quote may typically have between 1 to 10 child lines per quote. The child table (quote lines) is being sorted ascending on the internal Ninox ID both visually on screen and indeed on the print layout out (PDF) that gets issued to the client

This works fine until I wanted to add in a similar line to one of the lines already entered and have it show in position both on screen and on the print out! - ie

Line 1 Red pens printed in white x 500

Line 2 Blue pens printed in white x 1000

Line 3 Screens setup cost

Line 4 Carriage to one uk location

Line 5 Blue pens printed in white x 500 (this is the new line added after the quote initially done and clearly needs to between line 1 and 2) This coulf have been missed out at input time in error or the cliend does the usual - oh can you ad me etc......

The usual Ninox sorts are on this occasion not much use ie by description etc as this throws all the body visiually out! and sorting by the Ninox Id is no longer appropriate - So another field needed to be introduced (ie ‘QLnum’ - Quotes line order and is a number field) I inserted the following code on the table trigger on create!

let myQLN := max((select QuoteLines).QLnum); QLnum := myQLN + 2

Which gives me line numbers in incremental steps of 2 (1-3-5 etc.)

Thus I can simply change the newly added  line entry to say 2 and then my new line will sit within the position I need it. Better still was to make QLnum fixed at 1 dec place. 2.0-3.0 etc and that now gives me up to 9 lines of insert! 2.0 - 2.1 - 2.2 etc.

So okay onto my the issue

QLnum will forever keep adding numbers and the quote lines body will quickly get up to line 1501 etc. So I wanted a way to reset QLnum after x number of lines.

let myNum := last((select QuoteLines).QLnum); QLnum := 1 + myNum - floor(myNum / 10) * 10

The above partially solves my issue as I can now control the line number generation to x numbers and reset it after every 10-50-100 etc. Again great

But quote number 1 might have 6 lines and quote number 2 might have 11 lines

Thus I would end up quotes would have child lines that get reset part way through (not ideal)

So what I would like to do is reset the QLnum (quote body lines) back to 1.0 for every new quote generated

and then do my stepping of numbers as above to allow my inserts when and if required.

But just can’t quite get my head around this as I need the child table numbering to detect when a new parent table quote has been started.

Any suggestions ?

Also do you agree /disagree that the above stepping of numbers on an internal number field is practical/sensible or has any one got a better or more elegant suggestion?

Thank you in advance