Jump to content

Portal sorting on the wrong field


Tombstone0
 Share

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

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.

Link to comment
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.

Link to comment
Share on other sites

This topic is 7480 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
 Share

×
×
  • Create New...

Important Information

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