Self Join Portal Just repeats record

[DMilbrath]

Hello everyone. I am a newbie so please bear with me.

Here is my problem.

I have a db called actor. It contains the actor name and gender (male or female). My goal was to display 2 portals (one male) (one female) where user could select actor or actress and then go to the corresponding record.

Reading other post on this site i found what i thought was a great example of a self join that even i could not mess up (but of course i did).

I created a field called gender with a selection of "Male" or "Female".

I then created a g_male calculation field ="Male" and a g_female calculation field ="Female".

Next i created a relationship Actors( i thought was a self join) gender to g_male (for all matching males), and another relationship Actress's ( i thought was a self join) gender to g_female.

Then i created a layout with a portal that shows relationship Actor and field full_name.

What i get displayed is a single occurence of Actor that is "Male" repeated over and over again. Why? How do i fix it?

Can anyone help me with this. It is 7:30 a.m. here and i have been working on this for 5 hours and could use some help and some sleep .

Thanks in advance.

Dan

[Søren Dyhr]

I could have misread you, but it seems you have drawn the relation opposit of intended on the lefthand side of the relations def should be the constant and on the other side (righthand side) shoud it be the user chosen gender. The things I call contants is the two calc'fields.

--sd

[Ugo DI LUCA]

Also...

not Oslo, well you wouldn't care anyway Nice to see you here by the way.

Check that the fields in the portal do use the same relationship than the portal itself.

Well, for clarity purpose, a gFieldname would indicate that the field is a global, not a calculation.

If it was a global, you couldn't even use it as your Right key as it can't be indexed, but as you defined this key as a calculation, it works (FM will try to index it unless you specified not to).

Still your relationship is reversed as already said.

[DMilbrath]

Thank you guys. You have fixed my problem.

1) I did have relationship reversed.

2) I had fields in portal that were not in same relationship.

Thanks again....I am new to this and i appreciate you taking the time to answer my concerns.

D