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

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

  • Who Viewed the Topic

    2 members have viewed this topic:
    reynir  DavidTO 

Important Information

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