How to update a field via a calculation

[Tony]

I want to set up my database so that a when a user makes a selection in Field1 (radio buttons) Field2 then shows a figure based on the selection in Field1. So far I have been able to complete this but what I really want is to make it possible that if Field1 is changed in the future then a new figure will be displayed in Field2 automatically. I am missing something really simple I think - I need help please.

[Kurt Knippel]

quote:

---

Originally posted by Tony:

I want to set up my database so that a when a user makes a selection in Field1 (radio buttons) Field2 then shows a figure based on the selection in Field1. So far I have been able to complete this but what I really want is to make it possible that if Field1 is changed in the future then a new figure will be displayed in Field2 automatically. I am missing something really simple I think - I need help please.

---

Make Field 2 a calculation. You can also make it unstored, in order to have it update with more regularity, although it should automatically update.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=