ValueListItems not working

[Ozmaman]

First, thanks to all for the great information on these forums.

I'm using OS 10.3.9 and have two FM 6 databases, Stories and Pix. The two are related by a field-generated value list in Stories whose values can then be selected from a popup field in Pix. So far, so good ( think).

But the problem arises further down the road when I'm trying to generate a different value list (in Stories) of values from the related records in Pix showing up in a portal. Stories contains a field (:PicPath) in the portal, which displays data from a field in the related Pix records. It is the ::PicPath data that I'm trying to feed into a value list and can't.

My ValueListItems field - ValueListItems("Stories", "PixList") & Left(Count(Pix Link::PicPath),0) - isn't listing any values at all. It's blank.

Believe me, I've tried everything I can think of and I've already searched the forums high and low. Any help would be appreciated.

[Ozmaman]

Part way there. I added ".fp5" to the dbfilename of my ValueListItems field definition. Now it shows the first value in the portal, at least, but no others. What gives?

[Ozmaman]

Okay, it's working. Boy, do I feel dumb. The value list was using a field that couldn't be indexed.