Hello,

I have a problem with displaying related records from a match field in a portal.

Ok I have a field that users can enter search criteria. Ex) If they enter pr I would like to display everthing in the portal beneath the search that starts with pr.

I have a self join relationship with the search string(text,global) to a calculated field with the product including the number of characters.

Search_String <-> Left(Search_String;Search_String_Length)

(I also create the search string length from the first portal and set it as a global to create the calculation field).

I can not get this relationship to work, So if any one has any advise I would greatly appreciate it.

Thanks in Advance.

Your calculation appears to be dependent on a global field.

FMP can't index globals so it cannot make the relationship work. Normally when you create a relationship you get a warning to that effect, hoewever you have (latently) changed the field definition on the child side of the relationship.