... I have problems sometimes with buttons that are assigned a script to goto a layout when a certain criteria is met... the button ignores all the criteria and decides to default to the first layout in my list of approx 150 layouts (this happens approx 1/50 times)... why is this? (Multi User Solution hosted on Server 7).

How does the script specify the layout? Is it chosen from the popup or calculated. If it's manually specified, I'm stumped... If it's calculated, the calc must be returning the wrong name or # under certain conditions. As an extra check, put turn error capture on and check for an error immediately after the Go To Layout step.

its manually selected, i cant be stuffed writting out the script so attached is a screen shot...

p.s. there is nothing wrong with the relationship...

Edited October 1, 200520 yr by Guest

I assume the relationship is based off the "account name" field. In that case, I'm stumped. Have you tried recovering the file to see if it has any errors?

well no, how bouts do i go about 'recovering' the file?

Maybe there are no records selected or there is a record lock active.

The "Set Field" will fail in both circumstances.

Turn on error trapping at the start of the script, and write your own custom error trap dialogs ot report the error number.

See the FMD7 help for more info on recovering files, and error trapping.

will do, cheers