Weird value list behavior

[Rob Glaubitz]

I'm having troubles with a related value list with calculations. I used a self-join and a related value list to create a pop-up menu that lists all the names for that particular ID number (the ID is not unique). Works fine if the value list references a text field. However, if the value list references a calculation, then the results get screwy. Sometimes, they show up. Sometimes, they don't. Even odder is that it seems if you start with certain letters, there isn't a problem. For instance, anything starting with "t" seems to work. See the attached file as an example. Note the difference between the two value lists that should be the same.

Before you say that value lists don't work for unstored calculations, let me tell you that this IS a stored calculation that references no related files.

This seems like a bug to me. However, I might just be doing something wrong.

test.zip

[Rob Glaubitz]

Okay, I just solved my own problem. That's what happens if the output of the calculation is a number and not text. I changed it to text and now it works fine. Oh well. Hopefully, this will help someone else who did what I did.

[Vaughan]

"T" stands for True and FMP interprets this as logical 1. You'll also find that "F" gets interpreted as False and returns logical 0.