July 13, 200520 yr Newbies 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.
July 13, 200520 yr Author Newbies 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?
July 13, 200520 yr Author Newbies Okay, it's working. Boy, do I feel dumb. The value list was using a field that couldn't be indexed.
Create an account or sign in to comment