Hi all,

I have a script that performs a number of find request and the last request I want to limit to the first row of a portal only. At the moment the script steps are:

Go To Field: (selects the field in the portal)

Go to Portal Row [select;First]

Insert Calculated result( Enters the request data)

Perform Find.

 

I have tried moving the Go to Portal Row to the third step but get the same result.

 

What am I doing wrong ?

when in find mode there is only ONE portal row available.

I would recommend using SetField ( RELATED::FIELD ; "string or query" )

http://www.filemaker.com/11help/html/scripts_ref1.36.39.html

What am I doing wrong ?

 

You are not explaining what are you trying to achieve. Searching a related field searches the entire related set, in no particular order. What makes the first related record so special?

As well, your script never enters find mode.

You are not explaining what are you trying to achieve. Searching a related field searches the entire related set, in no particular order. What makes the first related record so special?

This is from a installations contact layout. The installation has a next service date which is used to contact and arrange a service,one portal shows the installation items but there is also a portal on the layout which provides a contact notes log. Perhaps the installation has been contacted to arrange a service but the the person responsible is not available so you make a note in the notes field and set a next contact date in the portal. The point of the find is to find installation who are due contact for service or because a contact date has been entered. From what you say it looks as though using a portal to keep and show the notes is not going to work.

From what you say it looks as though using a portal to keep and show the notes is not going to work.

 

No, that's not at all what I said. What I said is that you cannot search a related field for records that are in a specific position (e.g. first, last or third) within the related set. It's an 'all or nothing' deal.

 

 

I didn't understand your explanation that well, but it seems to me you could do one of the following:

 

• Search the notes(?) table directly for records that are due for service, but haven't been serviced yet. Then you can either do GTRR to show the parent installations, or use a layout of notes with fields from installations showing.

 

• Add a calculation field to the installations table, and search this field.