That's the trick...

[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

[wald]

Sorry y'all.

This was supposed to be a reply to another post.

oops.

-wald