Dear All,

I have a little problem when trying to work with self-join. Here is the problem. I got a database name A with fields company(text) and employee(text).

Since I want to know the name of each company . So I make the self-join on the Company. On the layout I put like this :

Relation : company

portal : relation: employee

that works ...but if I try to find in the portal , I type the name in the portal ..it give me everything. or I use script to find ...it give me everything ..like setfield(relation:employee,"Bill")

It give me all the name.

Is it the correct way to do it? And also using self-join we get the same record normal record ...it give same number of records of company.

Someone can help me with this?

Thanks

It's not clear to me what you want the result to be. First, I wouldn't base a relationship on company name. If you enter Sony Corp. it won't match Sony or Sony Corporation. It is best to base the realtionship on a company number you assign. Second, the Find you are discribing will find every record with the name "Bill" appearing in its portal. It WILL NOT find all the persons with the name "Bill" in the file!

-bd

It find every record with name Bill and not Bill in the portal ... what I want is when I want to find name Bill in portal ..it finds only name Bill in portal not other name in the portal. Example the result is Bill,peter ...I don't want peter included.

Someone has same problem using self-join ..I really have problem using self-join with portal.

If someones did self-join with portal, I really like to see it

Thanks.

I could not find exact match in portal ....it give me everything with the matched find ....Like when enter find mode in the portal...I type Bill ... it give me all records in portal with Bill and other name ...not just only Bill ....

Someone can help please ...since I have no clue where to start

Thanks