i must be a little dense i have tried to figure out by reading a few of the post heres about using global fields to do finds but i just dont seem to get it.

I have a portal with a selfrelationship using a calculation field which =1 as a key

now everthing works as far as the portal is concered everthing shows up in the portal but when i do a find for a perticular name say john i shows me all of the records including john,bob,querbet, etc i just want to see the records i did a search for what am i doing wrong is it in my relationship or do i need to use this global field that i keep reading about and if so how do i implement it can some help me with some advice thanks in advance

There is nothing like a run-on sentence to make things as clear as mud you know what I mean because this type of thing can get a bit difficult to understand it just continues on and on without any break I personally haven't done this since I was six at least not unintentionally just thought I'd mention it.

Deep breath.

Are you searching in a portal for a self-relationship? Why? Just search the fields themselves. If you're looking for records with the name "John", forget the portal and search on the name field for "John".

Don't know what your self-relationship is, but if (for example) you create one based on the FirstName field, then any record where the first name is John will show in a portal all other records where the first name is John, in which case you don't need to do the search.

Hi,

Searching in portal.

In brief, when you perform a find in a portal from a Main file to a related file, entering John would find any related records where John exists.

In your case, as you are in a contant selfjoin, all related records would show.

You have therefore 2 choices (that comes to mind right now) :

1. use a global field g_Name and create a relationship g_Name::Name.

Then perform a go to related record step using this relationship.

2. Search for a field "Name" that you would drop on the layout.

Now, the gloabl may be hided somewhere if you don't want to stand on the layout....