Field to auto populate if complex table has single record

[former_member199619]

Hi,

I have two fields of type complex table drop down (Plant and Storage location). Storage location field should get auto populated if the selected plant has only one storage location.

In the first selection of the plant, storage location field is getting auto populated correctly. But if I select the different plant (which also has only one storage location) second time, storage location field has the storage location of the previously selected plant.

[former_member199619 · Accepted solution]

Hi,

If I change the selection method to "Always Drop Down Menu", it is working perfectly.

For our requirement search functionality (Always Open Dialog with Search) on MaterialStorageLocation complex table is not required. 

-Shyam

[bill_froelich]

What platform / client and version of the Agentry client are you using?

--Bill

[former_member199619]

Hi Bill,

Agentry Editor: 70.8.0.10

WPF client of version 70.80.1.23

[Former Member]

Instead of using the Cascade Partent "Plant" can you create a rule to point to the current screen field you are using for Plant?

[former_member199619]

Hi Stephen,

I tried below rules, it is behaving same like when I set Cascade Parent as "Plant"

As the Storage location is not getting refreshed based on the selected plant, I createed a validation rule to validate the storage location. But when I debug it in Test Environment, correct storage location value is there in storage location property. My validation is like below.

My screen values are like below

By debug results

2015/09/16 14:22:04.160: + Rule=NewComponentAdd_ValidationRule

2015/09/16 14:22:04.160:   + Function=@IF

2015/09/16 14:22:04.160:     + Function=@EQSTR

2015/09/16 14:22:04.160:       + Property=:>"Plant" Property

2015/09/16 14:22:04.160:         Result<String>= '1250'

2015/09/16 14:22:04.160:       + Function=@COMPLEXTABLE

2015/09/16 14:22:04.160:         + ConstantTerm=ctMaterialStorageLocation

2015/09/16 14:22:04.160:           Result<String>= 'ctMaterialStorageLocation'

2015/09/16 14:22:04.160:         + ConstantTerm=StorageLocation

2015/09/16 14:22:04.160:           Result<String>= 'StorageLocation'

2015/09/16 14:22:04.160:         + ConstantTerm=Plant

2015/09/16 14:22:04.160:           Result<String>= 'Plant'

2015/09/16 14:22:04.160:         + Property=:>Current Screen Set>Current Detail Screen>"SLoc" Field>Current Property

2015/09/16 14:22:04.160:           Result<String>= 'CPSY'

2015/09/16 14:22:04.160:         Result<String>= '1250'

2015/09/16 14:22:04.160:       Result<Boolean>= true

2015/09/16 14:22:04.160:     + ConstantTerm=True

2015/09/16 14:22:04.160:       Result<Boolean>= true

2015/09/16 14:22:04.160:     Result<Boolean>= true

2015/09/16 14:22:04.160:   Result<Boolean>= true

Here CPSY is the only storage location available in plant 1250.

How my storage location filed should get refreshed based on the selected plant ?