Create sequential row numbers in invoice print form

@bflack - If I understand you right I do something silzer to this to auto input line numbers in the child table(subform). My need was to input line numbers is steps ie 2.4.6 etc. This then allows me to input and in between number ie 3 so that when the is sorted by the line number my quotes etc appear as I want them. Ie you input 10 lines and relaise you needs to insert one at line 6. After sorting i use another button script to reindex the whole record.

it's deffo not what you want but just might give you a clue ..

I'm guessing your header rows are pretty common so I would of thought that should be easy(ish) to cater for and skip.

Here is a quick screen shot- The button INDEX does the reindexing

when I enter product the save button throw all the data into the child form along with the QLNum being added (as said I do steps of 2 but it can be anything.

If you think useful as a starting point - I can load the scripts for each section. But apologies it won't be tonight as I now have to go out

Here you go

Some screen shots to explain my logic flow (as i want it)

Quote screen

Add a product

Pressing add a product button opens up the data entry pad for product entry

Enter products and press save. This same the line onto the sub(child) Table record and leaves the data entry fields intact so a quick edit can be made for same qty break and price etc. Save and clear clears the fields fro a different description etc and I will let you guess what X button does

Product line has been added to the bottom of the quote. However, in this example case I want to move it up to be in line 2. So I open the sub record and change the number of QLnum to 3. and Bob's your aunt Emma! - it shuffles the line up the page. 

I could leave it like this but i can also chose the to press reindex to change all the QLnum lines in steps of 2 - Yes I could automate this process as part of above but i like to manually do this.

Scripts

On form open - trigger after new

let before := max((select Quotes).QteNum);
QteNum := before + 1;
Choice := 1

this gives me my next quotation number

QLnun - Trigger after update - field on main form not same field on subform!

QLnum := max(QuoteLines.QLnum) + 2

Save Button

et xCurrRec := Id;
let xDesc := 'Product Description';
let xQty := Qty;
let xCostPrice := 'Cost Price';
let xMkup := Mkup;
let xSellPrice := 'Sell Price';
let xVatRate := 'Vat Rate';
let xSupplier := Supplier;
let xQLnum := QLnum;
let i := (create QuoteLines);
i.(Quotes := xCurrRec);
i.(Desc := xDesc);
i.(Qty := xQty);
i.('Cost Price' := xCostPrice);
i.(Mkup := xMkup);
i.('Sell Price' := xSellPrice);
i.('Vat Rate' := xVatRate);
i.(Supplier := xSupplier);
i.(QLnum := xQLnum);
QLnum := max(QuoteLines.QLnum) + 2

Index Button

let Zcnt := 2;
for Zql in QuoteLines order by QLnum do
    Zql.(QLnum := Zcnt);
    Zcnt := Zcnt + 2
end

As stated this does not answer your query but might be useful somewhere along the journey

I think that is it. But if there is anything else that is relevant etc I will add another reply

bflack @bfalc

Zql is simply the variable - I just called it that at time as I started my variables from A-Z an the "ql" simply means QuotesLine - I don't do this now as all my variables start with myXXXX and all my formula fields start with a small x - xCost etc

Steps of two's is simply to give me a point to insert into.. ie if all my lines were sequencial then i would have to modify several lines before I could insert a line. whereas I can add in a line buy changing the suggested QLnum(main form) before pressing save button. Thus QLnum (mainform) acts as both and editable insertion point and automates the next suggested line number.

My classic answer for this is as follows
I do a quote for a customer
Product1 x 72
Product x 144
Print screen
Carriage

Send it to the client. They come back and ask for product1 for 100 to be added to the quote - I need a quick way to insert it into the correct place/ or be able to shuffle the lines around to suit

 I only showed you one type of quote. We do have them with sku codes too. The principle is exactly the same - I do a dynamic lookup to get SKU info and auto fill in the other data entry description prices etc. QLnum is generated at the save button stage.

ah yeah - the saying is "Bob's you uncle " for their you go/ hey presto etc. It is just I saw a variation of this saying many years go in a comedy stage production and it has stuck ever since.....

You know what we brits are like !

@! bflack - Excellent - Glad you are sorted !