Hi Everyone,

Can anyone help me with this one please?

Having performed a find in one file, (by finding related records) and moved via portals etc to the file in which the data resides, I have the range of records and information I require (say 5 records).

In order to see one particular record of these five as it will be printed, I have to do a "find all / omit record / find omitted" and move to preview. Otherwise the first record of the 5 is shown in preview, not the one I wish to see. .... Ok so far.

My problem is that I then wish to return to my chosen range of records to deal with another of them. This effectively requires me to regain the original find request, not the last one.

Can I do this - if I could, how pleased I would be

If I could even do it before the football at 5.30pm ..... well words fail me.

Can anyone help please?

Regards, C.J.

OK --

I am going to presume you have a unique ID field for each record.

If you created a global field (lets call it gHoldFoundSet) you could create a relationship (lets call it rHeldFoundSet ] from this global to your unique ID field in this database. the global, although never stored CAN be used on the left side of your relationships.

Now, create a layout ( lets call it IDOnly ] where the only field on it is your Unique ID field

Now, in your script, when you go to look at a particular record

set Field [gHoldFoundSet, "" ]

## The set field clears the global field of any values

Go To Layout [iDOnly]

Copy All Records

Go To Layout [ A layout with the global field on it ]

Paste [ gHoldFoundSet ]

Show All Records

Omit Record

Show Omitted

## Continue your script here to go to the correct layout and preview etc

Now, when you want to return to your found set you have a script that is

Go To Related Record [show only related, rHeldFoundSet ]

HTH and done by 3.45 pm your time, so you should enjoy your football.

Thanks Andy, greatly appreciated.

I'll work on this and see how I get on.

Regards

C.J.

p.s. England won 2-1 (an all round good day !)

Hi,

For what is worth, I played witha file recently that allows multiple finds and flags to be "reminded".

Have a look and see here

Now, this was definitely a good day for England, which probably has the best Rugby team ever. Good things before the World Cup !

While Italy gently skipped Wales 4-0 (in Football) waiting for "Triumph" in Portugal Euro2004