Jump to content
Sign in to follow this  
Tombstone0

Portal sorting on the wrong field

Recommended Posts

I've created a portal between two files in my fmp database. In the define relationships menu I have sort set to sort by company name. Companyname is a calculated field in our customer database which looks up a company's name, it simply holds companyname so it can be used in this file. Anyway for some reason the portal is unwilling to sort on this field and sorts on company ID instead. Thanks for your help.

Share this post


Link to post
Share on other sites

make sure your calculation field is set to "Calculation result is [Text]" should be in a little drop down box in the window where you write the calculation. i have had trouble sorting by calculation fields in the past because i accidently had the result set to number instead of text.

hope it helps, if not post back maybe someone else will know what the problem is.

Share this post


Link to post
Share on other sites

Thanks bman,

but now I have the problem that the portal wants to constantly resort, it sorts when I open the window and then sorts when I click in the portal and will sort several more times. Is there anyway to get rid of this problem?

Share this post


Link to post
Share on other sites

Could you clarify? Is is resorting in the same order, just seeming to regenerate the portal, or is it resorting in a completely different order depending on which way the wind blows? (so to speak)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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