Record X of Y in a Cartesian join?

[Rich S]

Howdy, howdy...

Okay, what am I doing wrong: I'm trying to set up a calc in a Cartesian join and just can't get the X of Y record calc to work. Here's what I have so far:

Case(

Get( RecordNumber ) = 0;

"";

Get( RecordNumber ) & " of " & Get( FoundCount )

)

...so with six records in the found set the calc shows "6 of 6" for all six records. D'oh!

I know I'm going to kick myself when one of you wisened (or wise) guys tell me where I messed up. Good thing I'm not wearing pointed-toe boots.

TIA for your help!

[Vaughan]

Make sure the calculation is unstored.

[Rich S]

*heavy sigh* That, Vaughan, and it helps to define the field to look at the "child" table, not the "parent" one. :S

"Mission accomplished." Thanks!