No related Record

[Jessica]

Hi,

I have a button pointing to a related record in another d/b in a script.

d/b 1, script1: go to related record; goto external script in d/b 2.

d/b 2, script1: go to Layout Main

The problem is that if there are no matching related records, it still goes to the layout in main to the record it was last at which is wrong. It should have a message saying "No matching records"

Is there a way to prevent this? For example, is there a way to say "If (no related records) then..."?

Thanks!

[MeltDown]

First try de-bugging your script. Pause it before and right after each find...I've had problems if the field used for the find isn't on the layout used for the find, or other problems may turn up. If there just aren't any 'bugs', check to make sure 'Set Error Capture' is either set to 'off' or isn't in the script at all - this should allow the 'No files found' alert to come up automatically.

If Error Capture is not part of your script, or is already set to 'Off', try setting Error Capture 'On', then use an 'If' statement to display the message you want...something like...

Enter Find Mode

Set Field ["FieldName","Find Me"]

Set Error Capture [On]

Perform Find

If["Status(CurrentError)= 401"]

Show Message ["No Records Found"]

End If

Hope this helps! Good Luck!

[MeltDown]

Oops! Sorry, I hit the 'reload'! Can't seem to delete it!

[ July 02, 2001: Message edited by: MeltDown ]