Hi,

 

I was just wondering what everybody considers best practice in the following scenario:

 

In layout 1(table:invoices) on record 10

Go to layout 2(table:customers) and perform some finds and some field updates

Return to layout 1

# IS THE NEXT STEP NECESSARY?

Perform find (record 10)

 

When we return to layout 1, do we need to perform a find to make sure we are back on record 10, or can we rely on Filemaker to take us back to the last record on that layout?

 

It just seems that there might be an performance advantage in leaving out the find if you have a lot of records.

 

Thoughts, advice needed!

 

Thanks,

Christian

In layout 1(table:invoices) on record 10

Go to layout 2(table:customers) and perform some finds and some field updates

Return to layout 1

# IS THE NEXT STEP NECESSARY?

Perform find (record 10)

 

No.

 

can we rely on Filemaker to take us back to the last record on that layout?

 

You simply return to a layout that has unchanged found set parameters (found records, current record).

 

It just seems that there might be an performance advantage in leaving out the find if you have a lot of records.

 

Not to mention that this Find would restore the current record, but also leave you with a found set of one, which may be different from what you had when leaving that layout.

 

 what everybody considers best practice

 

You know the old adage: ask 5 experts, get 6 opinions …

If you start by opening a new window and close it instead of returning to the original layout, you will be returned not only to the same layout, found set and current record - you will also retain the current portal row, front tab selections, etc.

Keep in mind that opening a new window might have other implications.

Many of the older systems I work on are all PC users, and those users always maximize windows.

If you fall into this category, opening a new window, will change the size and position of the original, maximized window.

You would need to check if the current window is maximized, at the beginning of the script, then at the end, re maximize it.

 

Just another thing think about

 

Jerry