What is the calc for cCommissionDec?
from ApprovedArtistDetails, =CommissionRate/100
Basically coverts an inputed percentage rate into a decimal. AcceptedArtistDetails is a TOC of ApprovedArtistDetails.
You might try making that an auto-entered number field rather than a calculated field.
I have just tried that to no avail.
If I hold the calculation in Artworks, everything works fine.
The reason why I would like to hold the calculation in CommissionDetails is that I want to conditionally lock the CommissionDetails::cCommission field and any other field that concerns a commission artwork by locking the CommissionDetails table using priviliges if an artwork is a purchased item.
I really can't see why this is not working.
Your help is greatly appreciated