Dynamics Community Forum Thread Details

option set fields that each would filter based on the value in the field

I need to create three new option set fields that each would filter an option set based on the value in a field (the field is on another form).

For example:

Existing Data Key:

Bundle Field: Apple, Orange, Banana
DRG Codes Option Set: 1, 2, 3, 4, 5, 6, 7, 8, 9
ICD10 Codes Option Set: 10, 20, 30, 40, 50, 60, 70, 80, 90
CPT Codes Option Set: 100, 200, 300, 400, 500, 600, 700, 800, 900

Scenarios:

If “Apple” is in the Bundle Field,
1. DRG Codes Option Set should show “1, 2, 3”
2. ICD10 Codes Option Set should show “10, 20, 30”
3. CPT Codes Option Set should show “100, 200, 300”
If “Orange” is in the Bundle Field,
1. DRG Codes Option Set should show “4, 5, 6”
2. ICD10 Codes Option Set should show “40, 50, 60”
3. CPT Codes Option Set should show “400, 500, 600”
If “Banana” is in the Bundle Field,
1. DRG Codes Option Set should show “7, 8, 9”
2. ICD10 Codes Option Set should show “70, 80, 90”
3. CPT Codes Option Set should show “700, 800, 900”