Value list from calculated field

[blindbo]

Database A has a field "full name" based on a case statement that if field (1) is yes, then "first name" & "last name". This works properly.

Database B has a field that I want to display a pop up list from the "full name" field of Database A. Relationship is correct, yet I get no list.

Is it that I cannot have a value list based on a calculated field? If so, what might be the solution?

Thanks in advance.

[Lee Smith]

[color:"blue"] > Database A has a field "full name" based on a case statement that if field (1)

> is yes, then "first name" & "last name". This works properly.

> Database B has a field that I want to display a pop up list from the "full

> name" field of Database A. Relationship is correct, yet I get no list.

No, your relationship is not correct or it would work. The problem is you are trying to use the same field for your relationship and value list. You need to establish your relationship on some other field.

[color:"blue"] > Is it that I cannot have a value list based on a calculated field? If so, what

> might be the solution?

You can use a calculation, in fact, I often use a ~constant calculation of 1 in a relationship such as this.

I have enclosed two small files as an example of what you have described and a constant relationship.

HTH

Lee

blindbo.zip

[blindbo]

Thanks for your advice, Lee. Sorry it took me this time to respond.

Your sample with the constant is a nice solution. I can see where I will use it often!

Unfortunately, it did not work in my present issue, perhaps I descibed it bad, or it is just another quirk in my files. I DID however, come to this solution:

As you know, the field I wanted to use was a calc based on a case statement. I scripted an action that SET the field to the desired calc. Once that was accomplished, everything works. Strange, huh?

Thanks again!