jmci Posted January 5, 2012 Share Posted January 5, 2012 I'm working on my first data separation model project and it has an Invoice table. There is also a related Payment table. The Invoice table has a calculation field that sums the Payment::Amount field in related records. It also has a Balance calculation field that subtracts Invoice::SumPayments from Invoice::Total. In the user interface file I've created an Invoice form layout on which I've placed a portal to an occurrence of the Payment table. Rather than the user entering payments directly into this portal the user clicks a button above the portal that runs a script that opens a window containing a layout in which the user enters the new Payment record. I've done this lots of times before and it always works well but in this project I'm experiencing some anomalous behavior. Whenever the New Payment script completes, the Payment record doesn't appear in the portal until I click on the Invoice layout. Also the SumPayments and Balance fields don't recalculate until I click on the Invoice layout. Similar behavior occurs when I delete a Payment. What's happening here? What's the solution? Link to comment Share on other sites More sharing options...
Josh Ormond Posted January 5, 2012 Share Posted January 5, 2012 I know this will sound really simple, but I have to ask it...Do you have a Commit Record step at the end of the script? That is where I would start. Link to comment Share on other sites More sharing options...
jmci Posted January 5, 2012 Author Share Posted January 5, 2012 Yes I do. Link to comment Share on other sites More sharing options...
RalphL Posted January 6, 2012 Share Posted January 6, 2012 Take a look at this blog by Daniel Wood http://fmforums.com/forum/blog/12/entry-63-ditch-those-flush-caches-use-cartesian-join-instead/ it may be your answer, Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4494 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