Restore Find Requests

[Alex K]

Hi Guys,

Sorry, but I could not find anything on this when I did a search (never seems to work very well).

Anyway I'm confused!

I have users enter a find request, they can then flick through the found set and when they find the appropriate record select an edit button.

They are taken to an edit screen where they can only edit the record they selected - They then select the commit changes button and return to the main screen - which now only shows them 1 record.

I would like to automatically show the previous found set, flick through again and make other edits.

The reason for the edit screen showing only the selected record is that I don't want them accidentally changing something they shouldn't.

I've tried a couple of *hair brained* methods using globals to store the previous search, but it's not reliable.

This is probably a common function of a lot of databases but I can't seem to work it out.

I've tried using the restore find requests checkbox but it finds a different found set.

Maybe I'm thinking too hard!!

Help would be appreciated.

:bang:

[Ugo DI LUCA]

You can save your foundset by using an orphan TO using the same source Table.

Take a look at Rob Russel's article

[Lee Smith]

Hi Ugo,

He is using v6, is this doable in v6, because the article is talking v7

[Ugo DI LUCA]

My bad. Sorry this is 7 feature...

With FM6, you'd capture the foundset within a global field by a Copy All Records.

There's an example by Mike (Ender) somewhere about this technique, and many other posts too.

Edited :

here

Edited September 6, 2005 by Guest

[Vaughan]

"With FM6, you'd capture the foundset within a global field by a Copy All Records."

This is limited to around 8,000 records in the found set, because text fields are limited to 64,000 characters in FMP 6. If the record id is longer than 7 characters the number of records will be lower.

Have you considered simply re-performing the find again? The Modify Last Find script step is ideal for ths.

[Alex K]

Thanx guys,

I'll try the Modify Last Find script step idea first to see if that does the job (seems the easiest solution).

As for "With FM6, you'd capture the foundset within a global field by a Copy All Records."

I'm familiar with the terms "global field" and "copy all records" but this concept escapes me!! I'll have to think about this one a bit more.

From my previous programming experience I would have thought I could create a repeating global field as text (similar to an array) - set the fields to what the user entered in find mode - then at any time, go into find mode, re-import the data - and perform a find. I'd probably have to convert data types. Is this what you mean?

Unfortunately I'm developing this solution in my spare time, and I tend to forget why or where I was at. I need to go back to writing things down and checking them off as I go. (and staying off the alcohol might help!)

Cheers, thanks again for the wealth of info.

I'll let you know which solution works.

:beertime: