Hi,

I have a script that is acting erratically - usually it works as designed but randomly and infrequently it will fail to execute a Duplicate Record script step. I have read all prior posts on this issue but am still confused as to what is going wrong. Here is the start of the script.

Enter Browse Mode []

Beep

Show Custom Dialog ["Create a duplicate?"]

If [get(lastMessageChoice)=2]

Exit Script []

End If

Set Variable [$$BidID; Value:BIDS::Bid_ID]

Set Variable [$LaborRate;Value:BIDS::Labor_Rate]

Set Variable [$Percent; Value:BIDS::PercentToInvest_Default

Duplicate Record/Request

Set Variable [$$BidIDNew; Value:BIDS::Bid_ID]

If[$$BidID=$$BidIDNew]

Show Custom Dialog ["Duplication Failed...."]

Exit Script[]

End If

...

This file has no access restrictions. None of the fields are set to require verification.

The system is multiuser but I can't figure out how that would matter.

I have a theory that this only happens if the script is triggered while Filemaker Server is performing a scheduled backup. Any thoughts on this.

I have had similar issues elsewhere in system with go to layout script steps failing. Often this occurs if I am under the hood defining fields, but it also seems to be tied to the server backup schedule.

We are using 8.5 on mac clients, and server 8 on server on MacPro.

Thanks,

-Ted

I use server 8, and FM Pro 8 Advanced and have noticed that the "go to layout" script step will often fail (and go to the first layout in the list) when I have the "Define Database" window open. Perhaps the same thing is happening with the "duplicate record" script step for you?

Thanks for the reply Dan.

I have certainly seen the go to layout script step fail with the define fields window open.

Unfortunately the duplicate records issue has happened on days when I have not been here, and I am the only one with admin access to edit the system.