I have a file for staff which has input for first name, last name, 5 checkboxes (each a different field and value "1"), and 5 fields based on whether the checkboxes are checked or not. For instance, if the person belongs to the custom department, the related checkbox is checked and the persons first name is copied into the "custom department people" field. This is done by Define Database/Field=Calculation.

I can then create a value lists in separate files based on the fields in my staff file. So if someone belongs to the custom department, that checkbox is checked and their name will be copied into the "custom department people" field and listed in the value list in the separate file.

My problem is that some of these value lists work, and some don't. As far as I can tell, the fields are set up exactly the same. I can reproduce the error in the same staff file so it is not a file reference issue.

Any suggestions?

This is done by Define Database/Field=Calculation.

What does this mean? Is there a specific calculation you're using? Are the result types correct (text?)

If I were doing this conditional value list, I'd have one checkbox field with the different department names as choices. Then I'd use global text fields for the parent side of each value list's relationship. Each global contains one department name.

With this structure, only one field needs to be indexed for all departments, and the globals don't take up any space.

Ender, you are a frickin genius!!!

The one thing I forgot to check was the result type of the calculation.

Everything is now hunky-dory!

Thank you.