I'm creating a job-costing system and my JobCost datapage receives information on charge rates from my ClientInfo Table. So, in simple terms, the JobCost will calculate a charge based on the number of hours x charge rate shown in the ClientInfo table.
My problem is this. When the ClientInfo is adjusted to reflect a new charging rate, ALL records in the JobCost are updated - not just new ones. Is there any way to prevent historical information in reports from being updated in this way?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Spearheading
I'm creating a job-costing system and my JobCost datapage receives information on charge rates from my ClientInfo Table. So, in simple terms, the JobCost will calculate a charge based on the number of hours x charge rate shown in the ClientInfo table.
My problem is this. When the ClientInfo is adjusted to reflect a new charging rate, ALL records in the JobCost are updated - not just new ones. Is there any way to prevent historical information in reports from being updated in this way?
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.