Forum Discussion
DavidBrogdon
7 years agoQrew Assistant Captain
Amber,
From what you described, it sounds like the hourly rate is pulled from a field on the "Labor Category" table. If this is the case, it won't change when changing CLIN Summary because CLIN is not the table supplying the value.
There are a few options, but I would need to know more about the functions and purpose of each table to give direct solutions.
Is it possible the change the labor category table to the grandparent table and pass the field down through CLIN and to Burdened Labor table? If not, is it possible to calculate the hourly rate via a formula field on the labor category table that looks at a particular flag on the CLIN table?
From what you described, it sounds like the hourly rate is pulled from a field on the "Labor Category" table. If this is the case, it won't change when changing CLIN Summary because CLIN is not the table supplying the value.
There are a few options, but I would need to know more about the functions and purpose of each table to give direct solutions.
Is it possible the change the labor category table to the grandparent table and pass the field down through CLIN and to Burdened Labor table? If not, is it possible to calculate the hourly rate via a formula field on the labor category table that looks at a particular flag on the CLIN table?