Calculation Modification

[mike bell]

I have a field that is a calculation.

And is set in the layout as a Pop-Up List.

Can I modify the Pop-Up List without getting the error "This field is not modifyable"?

What I am trying to do is this:

I have to database files. One is jobs.fp5 and the other is to_do.fp5. Both, have a status field, which are pop-up lists with values: incomplete, in progress, in print, received, etc..

I want to be able to be in either file, make the change to status and have the other files pop-up list change as well. I could do it with a script, if I have both files opened side by side then it doesn't display until a button is pushed.

Any help would be greatly appreciated.

Michael

[Vaughan]

You can only "change" a calculation field by editing one of the fields that the calculation is based upon. If the calc was:

If ( isempty( field ) ; "no" ; "yes" )

...the only way to change the calculation result is to change the value in "field".

Formatting a calculation field as a list or menu won't change the fact that it can only be changed by editing one of the fields that the calculation is based upon.