Your save script definitely creates a new record, but then it closes the current window. Thus the window where the new record is created doesn't have the same found sets (one to every Table Occurrence) as that in the window now visible after the first window was closed. What you see in the window still open won't be affected by the creation of the new record in any way except to change the found count and total records figures in the status bar and then only if the layouts in both windows are based on the same data source table.
Do I need to put Go to Layout and Go to record request after my close window line in my save script?
1 of 1 people found this helpful
I'd have to open the file and take a look at it to give you specifics. (My machine is currently crunching through a FileMaker task that is taking much longer than anticipated.)
It depends on your layouts, their table occurrences and the found set in your original window before your script did its thing in a different window.
Might just need to add Show All Records followed by go to record [last] if its in form view.
Thanks Phil..I will wait for your input.
Well; no surprises here.
There is nothing in your scripts that indicates you want to navigate to the new record.
Yes, Phil's suggestion to show all, create record in new window, close window, go to last, would work.
But if you might sometimes intend to work with a subset of records, you may want a different approach.
Such as capturing the MaterialID of the new record and doing a find for that.
Or setting up a global gMaterialID field; and a relationship; and go to related record.
Might be handy to have that nav script anyway. Pass it a MaterialID, go the correct record.
Inventory MODBFR.fmp12.zip 171.4 K
And actually; combining Extend Found Set and GTRR works best.
By passing the new Material ID to an Extend Found Set script; the new record is added to the found set.
But that does not take you to the new record.
If you also use a global field for gMaterialID and then GTRR to that record, you achieve both results.
If the layout is sorted, the new record will appear in the correct order place and you will go to it.
Inventory MOD2BFR.fmp12.zip 173.2 K
Thanks Bruce...now it works..