swf Posted September 20, 2006 Share Posted September 20, 2006 I attached a samplefile. I want a field to update based on the last portal entry. I have created a relationship to isolate the last portal record. If I create a calculated field it works fine. However, I would rather a regular field that autoenters with the same calculation. The reason is simple. The field will usually but not always be based on the last portal and the user may need to override the calculation. Please take a look. test.fp7.zip Link to comment Share on other sites More sharing options...
BobWeaver Posted September 21, 2006 Share Posted September 21, 2006 It generally doesn't work when you base an autoenter calculation on a related field, because Filemaker only triggers the calculation when is sees changes in the current record. I suggest that you use a calculated field, and then create an additional field where the user can enter an overriding value. If you superimpose the two fields, then they will appear to be a single field and will work as you want. See the attached file. Also have a look at how the field behavior is set up for both fields. test.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6519 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 accountSign in
Already have an account? Sign in here.
Sign In Now