Jump to content
Sign in to follow this  
Russellware

Search of populated portal returns no records

Recommended Posts

Hi all--I am getting unexpected behavior in a portal. I have an inconvenient work-around, but I'd rather understand what is happening. The native key is a single line text calculation, and the foreign key is a multi-line text calculation. I see data in the portal, but performing a find returns no records found, whether I search for specific data or "> 0" or empty. I built test files duplicating the fields and relationships, and the problem persists. When I change the NATIVE key to a text field, the problem goes away. Any ideas what I'm missing? The work-around is to regularly update the native text field with the calculated results of the native key, but that's counter-intuitive . Thanks in advance!

Share this post


Link to post
Share on other sites

Make sure the data types of the two keys are the same -- number, text, etc. Weird things happen when the data types are different, especially text & number mixed.

Share this post


Link to post
Share on other sites

"Performing a find" - on what? You haven't described what you are doing.

Share this post


Link to post
Share on other sites

Is your single-line text calculation stored or unstored?

Share this post


Link to post
Share on other sites

Thanks, Vaughan. I actually figured it out--my native key is a calculation based on a bunch of related fields (Contacts_ID::CompanyName or Contacts_FirstName::CompanyName, etc.). In Find mode, that calculation is empty or invalid, therefore the relationship is invalid, therefore no results are found. I've been doing this a long time, and this the first time I've boxed myself into an invalid relationship with the NATIVE key. [i say quietly to myself, "Duh."]

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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