self-join relationship see's itself

[Irene M]

I have a file showing work lists per part with a self joining relationship that shows all open work lists for the same part. It works great, but the portal shows also the record itself.

Is there a way to show only the related records buy not the one we are in?

[Kurt Knippel]

Not without some extremely complicated calculations. It is possible though.

Basically you need to match on all records except for the current record. I do not know that I can easily find the calculation, but the theory is something like this: You need to capture the IDs for all records in the set and then using a text function (such as Substitute) you need to have another calculated field which replaces the ID of the current record with "". Then this calculated field is used as a multikey to match to the IDs and display the portal.

[-Queue-]

Sure you can, provided ValueListItems() doesn't exceed 64K, using this 'Remove Rows' technique.