Hi teamI'd greatly appreciate some assistance with this issue please Table setup: Table 1 - CMC case type 1 (Onboarding Case) fields onboarding case id onboarding case parent id milestone id Table 1 - CMC case type 2 (Onboarding Subcase) fields onboarding subcase id milestone id Table 2 - Onboarding Case id case id = CMC onboarding case parent id Table 3 - Onboarding Subcase id case Id = CMC onboarding case id Note: Each onboarding case can have multiple subcases. Each subcase represents a product to assess. The flow goes roughly like this: show list of products -----> select one product -------> update selected product milestone -------> start assessment process This part works fine but I need to find a way to update all the unselected rows so their milestone value can be changed.Any ideas? Blessings Stephen

Question

Changing data for rows NOT selected in a read-only grid

Hi team

I'd greatly appreciate some assistance with this issue please

Table setup:

Table 1 - CMC
- case type 1 (Onboarding Case)
- fields
  - onboarding case id
  - onboarding case parent id
  - milestone id

Table 1 - CMC
- case type 2 (Onboarding Subcase)
- fields
  - onboarding subcase id
  - milestone id

Note:

The flow goes roughly like this:

show list of products -----> select one product -------> update selected product milestone -------> start assessment process

This part works fine but I need to find a way to update all the unselected rows so their milestone value can be changed.

Any ideas?

Blessings

Stephen

Sure. Query that unselected items, modify them, and write them back to the DB.

You can use the deselectedRows variable to capture and update the related entries

Create record relationship with each other table, select check box "update related records" while creating relationship.

Thanks, the relationships are set up already.

Blessings

Stephen