Jump to content
Steven Cappiello

ValueListItems( ) returning nothing via a working relationship & related value list

Recommended Posts

I suspect I’m forgetting something simple. I have a relationship and I’m successfully showing the correct related records in a portal.

On that same layout from the context of that main table (not a TO of it), a calculation is failing with    ValueListItems ( Get(FileName); “valuelist_name”)  It’s coming up blank. The value list however, is working. It is being evaluated from the context of the main table. When I put a field on that layout and assign the value list to a drop down field, I see the values. How on earth would this ValueListItems function be failing. 

Other calcs in this solution (albeit in a different table) with ValueListItems ( Get(FileName); “valuelist_name”) are working so it’s not a problem with Get(filename) or the file as far as I can tell. The selected field in the related value list is indexed, and the calc trying to use ValuelistItems ()  is unstored.   Any thoughts about what I might be doing wrong?

The relationship is a self-join to a TO of the same table, from a stored calc in the main table resulting in a text field (the word "yes"), to another text field in the TO which is an indexed text field in which some records contain the word "yes."  Like I said the drop down list is working.. Any idea why ValueListItems( ) is not ???

Many thanks in advance. 


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.

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.

  • Who Viewed the Topic

    1 member has viewed this topic:
  • Create New...

Important Information

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