Updating records after entry
I have a product table linked to a usage table.
If I use a product to generate a job cost then the cost of the product is looked up from the product table.
This is fine until the price of the product changes. The job cost is not recalculated when I go back and review the job. Sometimes I do not have the current price when entering the job details.
Is there a way to get over this problem ?