indexing fields

[lrcarey]

Hi,

I'm trying to create a relationship that will allow for one file to count a certain subset of records from another file, which in turn is pulling the information for its records from another file. For instance, I want file B to count all records in File A that have pulled in the ID "A" from its related file AND that have then been designated as "option 1". When I try to create the relationship, it fails because the concatenated field ID.option which registers "A option 1" can't be indexed. I don't understand why some calculations can be indexed and some can't - and what do I do to make this one index so my relationship works?

Thanks in advance for help!

Leah

[LiveOak]

Any field to be indexed must be stored. The field on the right side of any relationship must be indexable. Calculated fields which use related fields cannot be stored or indexed. Your only option is to copy the data from the related field into an indexed field in file A.'

-bd