Populating a Complex Table based on selection from a complex table drop down

[Former Member]

Hi,

I am trying to populate a complex table by selecting a value from a drop down which has been created using the same complex table. It has 3 fields- Type, Key , Value. The type column has values a,b,c,d etc. On selecting a particular type from the drop down, I want the drop down to be re-populated with the values corresponding to the type selected.

Any suggestions on how this can be achieved.

Can I add a filter to my complex table drop down (Other than an index field or cascade parent object)?

Thanks in advance

Amitoj Singh

Tags edited by: Michael Appleby

[bill_froelich · Accepted solution]

Amotoj,

This scenario is exactly what the Cascade parent is meant for.   You would define your screen to have multiple fields where if you select a value in field 1, field 2 will be automatically filtered based on the first selection.

You will need the appropriate indexes on the Complex Table to support it but it is fairly straight forward.

If there a reason you don't want to use multiple fields?

--Bill

[jason_latko]

Amotoj,

Use a cascade and two fields like Bill suggested.  Trying to do this with a single drop-down is not really possible.

Jason Latko - Senior Product Developer at SAP

[Former Member]

Thanks Bill, Jason

I'll try it and get back to you.

Regards

Amitoj