Hi,

I've converted/migrated about 60% of my solution to the new FileMaker Pro 7 formats. I am stuck on the elegance of one command in my database, the duplicate button, a technique that I learnt from the excellent John Mark Osbornes databaspros website.

You can see in my example the, the freeze window command works quite effectively in my FM 5 files, however in my converted files the Freeze window script doesn't perform terribly well, as it opens the related file and then closes (its only a second-but its really irritating!).

ANyone, know how I can force the screen to Freeze while the "related" records are being duplicated?

Any help would be kindly appreciated, i've included both my files for any would be helpers.

Cheers

Jalz

DuplicateJalz.zip

I also could not get it to stop flashing - if the Loop script is run in the other file. However, when I put an occurrence of the 2nd file into the 1st file's relationship graph, created a layout for it in the 1st file, then ran the duplicate Loop operation there, it didn't flash at all.

So that's the answer, to avoid flashing create a layout for the external file in the calling file, and run scripts there. It's almost the same script.

DuplicateJalz.zip

Thanks Fenton,

Your example works a treat, now I've got to try and implement it in my solution which has about 20 of those types of scripts.

Jalz

Good. It helped me also, as I hadn't really had to solve that particular problem in 7 before. Not wanting to mess up a good thing, but I kind of have to wonder why you would have 20 different "duplicate this record and all related records" scripts. One wonders if there is a better relational way to solve whatever problem it is with the data?