Ok I am tring to put a list view or portal to create a list of all employees co you can click the name and goto that record. How do I make a portal in the same File that will actually show all names instead of just the one I am on. I think I can get goto record to work if someone can help me create a portal list of names that reside in same File.

Thanks

Tony D.

Create a new field, Calculation and enter "1" (without the quotes) as the calculation. Now, create a relationship where this field is the key on both sides. What this basically does is relate all records to all other records.

Now, create a portal based on this relationship and you will be able to view all other employees from every employee record you are in.

See attachment.

Regards,

Peter

Selfjoin.zip

Welcome to version 7, Peter.

Selfjoin.fp7.zip

Whoa, Michael! I knew about Cartesian but I always joined a field to a field (any field but container) even mismatching them in glee - but this?!! I'm glad I took the time to look!!! How on earth did you join no field to no field! This blows my mind!!

Ooop. Figured it out! You use the 'Add Relationship' button instead of dragging field to field! Cool! I've always dragged to create my joins. This tickles me!! :grin:

Adding a relationship doesn't work for me. I have simply deleted Peter's constant field.

Ah. I didn't carry it far enough. It opened with both TOs and it looked just like yours. I didn't bother actually trying to attach. I need to carry tests through to culmination, I see. Darned! I thought you popped out another miracle! :D

Bad news folks for some reason it puts the same name for 9 lines in a row and the name it is using is the record I am on!

Any Idea what I did wrong

Try putting RELATED fields in the portal?

Got it I had a calculation field in the portal Connecting first and last name. Made a new Field that was a text field and bam working!

Thanks Folks

Whoa, Michael! I knew about Cartesian but I always joined a field to a field (any field but container) even mismatching them in glee - but this?!

Yes he've done it again!!! It reminds me of the speediest way to pass a value over a relation is over an illegal one - that is a global field on both sides.

http://www.kevinfrank.com/download/df_invalid_relationships.zip

At least with the illegals is it that the index for a global field is pretty short to say the least, but this one makes me scatch my head, it must have some bearing to overlayed code i guess? Just like this:

http://www.sumware.net/robfm/savingfoundsets.php

--sd

Knowledge fodder :woohoo:

This is very cool indeed. When I started with 7 a while ago I know I noticed the introduction o f the Cartesian join but forgot all about it.

The way you implemented it is very cool indeed, but isn't that actually the way one should expect it to work ? FM help says

All records in the left table are matched to all records in the right table, regardless of the values in the match fields

Would that not imply that to establish such a relationship, no fields should be required ? And that therefore, FM has not correctly implemented the creation of such a join ?

Still a cool trick by the way

Peter