rivet Posted April 22, 2006 Share Posted April 22, 2006 I have an invoice system with line items for parts and line items for labour. I would like the sub total to be a number field instead of a calculation. But I can not get a result with the number field having a auto-enter calculation of sum (relation::amount). I would like to avoid scripts for now. I would like the subtotal to be a number field so the DB remains fast and doesn't get bogged down over time and when performing reports. Link to comment Share on other sites More sharing options...
mz123 Posted April 23, 2006 Share Posted April 23, 2006 Have you tried a summary field? The summary would be the total of the "amount' field. Link to comment Share on other sites More sharing options...
IdealData Posted April 23, 2006 Share Posted April 23, 2006 I think "rivet" is looking for something beyond this. The issue surrounds performance degredation with calculated values. The auto-enter cannot work as it will evaluate on the first valid entry on a dependent field, from there on it will not re-evaluate. About the only way to test the possible performance issue is to fill a dummy database suite with random values and see what happens. Try 10,000 records first then move upto 100,000 etc. I have seen systems with > 100,000 records and quite a few calcs that have acceptable performance. There has to be some level of compromise as the database is doing a lot of work, so all it is asking is a little time, other than this you must script it. Link to comment Share on other sites More sharing options...
rivet Posted April 23, 2006 Author Share Posted April 23, 2006 then scripting it is... thanks for the help Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6577 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