Jump to content
Sign in to follow this  
mike bell

Calculation Modification

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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