Jump to content

using a global field for a value list


shogunjp

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

Recommended Posts

Any suggestions?

Reason: This is a non-profit membership database, it generates a list of current board members by searching the database for the checked board member option, it then compiles the persons full name and places it into a Global field, it repeats this for all current board members. I then want that global field to be the basis for a value list, so we don't have to alter the value list everytime the board member list gets changed...

Thanks

Link to comment
Share on other sites

You don't need a global field. Create a calculated field for full name. Call it "Board_Member". Example calculation:

Case [checkbox="Yes",First_Name & " " & Last_Name]

Your Value list then is based on Field contents of the "Board Member" field.

Link to comment
Share on other sites

It didn't work, the check box and the name fields are not located in the same database, (they are related through an ID number) Because of this, filemaker can not turn indexing on. Therefore, Filemaker can not turn the calculated field into a value list.

Link to comment
Share on other sites

Another quick thought: What if the Check box field is actually in the same database as the names, and you use a relationship to display it in the file it currently resides in. This way the "name" field could be indexed because it is no longer depending on a related field.

Link to comment
Share on other sites

This topic is 8459 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.