Newbies Rob Glaubitz Posted November 26, 2002 Newbies Share Posted November 26, 2002 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 Link to comment Share on other sites More sharing options...
Newbies Rob Glaubitz Posted November 26, 2002 Author Newbies Share Posted November 26, 2002 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. Link to comment Share on other sites More sharing options...
Vaughan Posted November 27, 2002 Share Posted November 27, 2002 "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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7949 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now