Conditional Dropdown - Not updating on report link

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
I have the following tables:

CLIN Summary
Labor Categories
Burdened Labor
Service Orders

CLIN Summary has a one-to-many relationship with Labor Categories, where one CLIN Summary has many Labor Categories.  CLIN Summary also has a one-to-many relationship to Service orders, where CLIN Summary has many Service orders.Labor Categories has a one-to-many relationship to Burdened Labor, where one Labor Category has many Burdened Labor.  And finally, Service Orders has a one-to-many relationship with Burdened Labor, where one Service Order has many Burdened Labor.

When my user enters a service order, they will add the appropriate burdened labor (which correctly pulls the labor category based on the CLIN selected in the service order).  The hourly rate of the burdened labor is entered via lookup from the Labor Category table.

What is not working.  If my user opens the service order under CLIN Summary A, and then at a later date changes the CLIN Summary to B, the hourly rate isn't being updated.

Is there a way to have the hourly rate lookup field change when the CLIN Summary is changed without having to select a different Labor Category?
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb

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?