I do have a relation between 2 TO (Tables) that way:

STUDENT (ID, Name, GroupID_fk, GroupName (Calculation: Unstored: GROUP::Name), ...)

GROUP (ID, Name, ...)

STUDENT::GroupID_fk ----[=]---- GROUP::ID

When I sort using the "Sort Records..." menu command using "STUDENT::GroupName" it doesn't sort and produce the same output as "Unsort" but when I do use "GROUP::Name" it does sort correctly.

Till it's a calculation field using a field from another table, I can't force it to be stored rather than "unstored and calculated when needed"

Is there something I missed?

Is your application patched up to 7.0v3?

Not related to your question, but the calculation field seems redundant - you can simply place the related GROUP::Name field on a layout of STUDENT.

Versions:

FileMaker Pro 7 7.0.3.320

FileMaker Dev 7 7.0.3.320

Can you post a simple file showing the problem?