Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7281 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted

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.

This topic is 7281 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.