Perform find in first portal row only

[Oyseka]

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 ?

[Ocean West]

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

[comment]

  On 11/21/2012 at 8:31 PM, Oyseka said:

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?

[Rick Whitelaw]

As well, your script never enters find mode.

[Oyseka]

  On 11/21/2012 at 9:09 PM, comment said:

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.

[comment]

  Quote

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.