I wrote a script to go to a specific screen to conduct a find. If no records are found FMP takes the user back to the original layout but not to the record the user started from. A blank screen appears. Is there anything I can put in the script to have the user returned to the record from where they started?

The user cannot altered the fields on the screen that they are viewing so the find function is stored in a button that takes the user to a screen where they can access all of the fields to key in search criteria.

FileMaker Version: 6

Platform: Mac OS X Panther

Relate a global text field to the id field. Before performing a find, set this global with the current record id. If no records are found, Go to Related Record [show, gID_to_ID].

Fantastic fix. Works great. Thank you.

FileMaker Version: 6

Platform: Mac OS X Panther

Queue,

I thought a global field couldn't be used in a relationship because it cant' be indexed. When I've tried something similar I got a warning error when defining the relationship.

Also what is the 'Show' in the Go to related record calc?

Hi Glenn,

You can use a Global in the left side of a relationship (Current File), but not on the right side (Related File).

Lee

Very handy piece of knowledge, thanks Lee!

The 'Show' is for the 'Show only related' checkbox.

FileMaker Version: 5

Platform: Windows 2000