self-join, excluding current item

[wald]

I have a layout which is used to track art items that have been ordered by customers. The layout shows a single item, where it is in production, etc.

In this layout, I need to show all of the other items that were ordered with the piece shown. However, I don't want the item shown to appear in that list (that would be confusing to my users).

I easily created a portal with a self-join that shows all of the pieces in the order.

How would I modify the self-join relationship so that it shows all of the other peices in the order, EXCLUDING the currently viewed item?

Thanks.

-wald

[Garry Claridge]

You may be able to create some sort of calculated key that the 'Current Record' does not match. You can create a relationship with this key, and hence an other portal.

All the best.

Garry

[wald]

Any ideas how to make such a calculated key?

I tried playing with Status(CurrentRecordID.

I made a field called FM_Static_RecordID to store the RecordID.

Then I made the relationship calculated key:

If( FM_Static_RecordID=Status(CurrentRecordID),"",order_ID)

But this doesn't work.

Any ideas?

Thanks.

-wald

[BobWeaver]

On the surface, it sounds possible, but I suspect that it's not. At least not without some extremely twisted calculation or some strange programming trick. This reminds me of Groucho Marx's famous remark: "I would never join a club that would have me as a member."

You are trying to do the Filemaker equivalent.

As a workaround, you could use Oceanwest's ValuListItems trick, and use the substitute function to remove the current record data, but it wouldn't be in a portal.

[ November 04, 2001: Message edited by: BobWeaver ]