Jump to content

Value list from calculated field


blindbo

This topic is 7552 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

[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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 7552 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.