Conditional Dropdown - Not updating on report link
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?
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?
