How to create a button that clicks through forms

Nick looking for my issue I came across this post.

I Need some help please, as I cant figure out, how the Script would be when I would Click next record in subtable?

I tried with select yourtable.subtable, but it doenst work.

thnx

Kruna is the "next" button in the "subtable"? I put it in quotes because when you are in the record of the subtable then the "subtable" is now THE table. You can use the reference field back to parent table to get the records that in the subtable.

let t := this;
let allSubtableRecs := parentTable.subtable;
let countSubtableRecs := length(allSubtableRecs);
let currentIndex := index(allSubtableRecs,t);
let nextRec := item(allSubtableRecs, currentIndex + 1);
popupRecord(nextRec)

You don't need line 3 for this part of the code. I was thinking I would use this to do some checking to make sure where you are in the array. But I thought it would be better to use it in the Display only if and hide the button when it is not needed.

I used popupRecord() because openRecord() didn't do the right thing for me.

Fred hi Fred, yes I forgot to mention that the button has to be in Main table, I mean parent table.

I tried your script, but it just opens the First record of the subtable.

thnx

Fred edit:  I dont get the second line to work.

yes I forgot to mention that the button has to be in Main table, I mean parent table

Then that would mean you have to close the child record to open the next one. My script is for a button in the child table.

I dont get the second line to work.

Since my script starts in the child table, you just need to remove the parentTable reference if you are in the parent table.

Fred yes, I have an Script for the Button in Child table, but how would be the Script for parent table?

Thnx

KrunaI'm not sure why you would have a button at the parent table. Once you open a child record, it would seem like to me that the Next button should be there.

But if you really want it in the parent table then you need a number field to track which record you are on. I created one called currSub with a default value of 0. Then your code could look something like:

let allSubRecs := subTableField;
if length(allSubRecs) = currSub then
    currSub := 0
end;
popupRecord(item(allSubRecs, currSub));
currSub := currSub + 1

Line 1, creates an array of the child records.

Lines 2 - 4, checks to make sure that we don't go over the number of linked records.

Line 5, popups the item in the array according to the number in currSub, starting with 0 and going up from there.

Line 6, increases the value in currSub by 1 every click of the Next button.