J__ Posted January 26, 2005 Share Posted January 26, 2005 Hi, I have 2 tables, among others, they are tasks - invoiceLine Items table. I have a relation between the two and in the Tasks table i have a calculated field, which is unstored and sums up all the invoice line item records for each task. So, each time an invoice is request is entered, when you look at the tasks table, you'll see the "Total_Paid" field in each record of all the invoice line item records entered with the id in it. This has all worked fine - in a multi-user environment for awhile. For some reason, which I'm trying to determine and I hope maybe someone has seen this. The other day the Total_Paid field stopped showing/summing. Of course, the line items were there, but it wasn't summing them up anymore. I had imported the current data into a new database and we were using that. The same data was put back in as was there before and the backup copy i had worked fine too upon testing it. We stopped the server, restarted and it was working again. any ideas why this might happen? OR has anybody ever seen this before and if so, what did you do? It was just a little "twlight zoneish", so I thought I'd ask the forum. thanks, Sincerely, J__ Link to comment Share on other sites More sharing options...
This topic is 6638 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 account
Already have an account? Sign in here.Sign In Now