Relationship based on unstored calculation?

[Anh_Tran]

Hi All,

I have 3 fields ...name, department, score

Name A, Computer, 100

Name B , Science, 90

Name C , Computer, 20

Department is an unstored calculation, how many department in the file, I could get the average of score of that department. In this example, it produces 2 department with Computer and Science. But the problem is deartment is an unstored calculation, is there a way to achieve this???

Thanks

Anh Tran

[cjaeger]

there are several ways to make [a copy of] an unstored field an indexed one. Or you could do a scripted find.

a) copy-of-field= Getfield("field")

: a 1:1 relation based on uniqueID

copy-of-field: autoenter lookup [self|unique::field]

but I'd rather check whether department can be made stored (via a lookup, for ex.)... departments don't change that often.

[Anh_Tran]

Oh...if department is an stored field then I use the relationship department:department :

but how can it know how many department in that finding to sort out??? we use script find and enter Preview mode right?

Thanks