FMP6 Auto-Enter Calc Result and Indexing

[SparhawkTech]

Fields in my table:

kStudentID - Indexed, Text Field

kDomain - Indexed, Text, Auto-Enter Calc Result

kSection - Indexed, Text, Auto-Enter Calc Result

kcStudentSemester Indexed? Unstored?, Calculation

(concatenation of kStudentID & kSemester & kSection based on the value

contained in kDomain)

I am having trouble using kcStudentSemester in a relationship based in another table; FMP6 tells me the field is not Indexed so the relationship won't work.

When I go to the field and set the Storage value to either Off (turn on when needed) or to On, it sets the field to Indexed in the Define Fields list. When I get out of Define Fields mode, it processes the field definition. However, the setting doesn't stick; the relationship still doesn't work, and the field gets listed back to Unstored when I get back into Define Fields.

kSection & kDomain both have Auto-Enter calcs that take a look at related fields. I thought this was only done at record creation. Does FMP6 have trouble indexing even when the field uses a related file/field in an auto-enter calcualation?

Let me know if you have questions. I think it does have this problem, but please confirm for me if you know the answer. I'd like to stop beating my head against a wall getting it to work this way if it's not possible.

[-Queue-]

I've had issues with this also. Try using a lookup instead of an auto-enter calculation or use a true calculation field and a self-relationship to lookup its value.