dynamic cascading prompt

[jschill2628]

I need to create a dynamic cascading prompt. With this said I want it to be based off of another static prompt.

My first prompt (static prompt) have a list of codes and descriptions:
Fall- Fall
MED- Medication
SURG- Surgical, etc.

What I want to be able to do is when the user picks one of more of the values from the static prompt; I want another prompt to show my severity levels (none, minor, major, etc.)

The really tricky part about this is that between my 10 event types listed in my static prompt, there are three different severity scales. One for Falls, one for Med and one for the other 8 event types. These severities are all listed under different fields.
SA20- for falls
SA150- for MED
SA153- for All Other

Can someone help me with this?

Thanks in advance.

 

[lbass]

You need to identify the table and field for each field you reference, using the convention {table.field}. Are the severity scale fields in the same table as the code field? Or are they each in a different table? If they are in different tables, how do the tables link to each other?

You also need to identify your CR version--you should always do this.

-LB

 

[jschill2628]

CODE:
Fall Severity:
IRSCLAIM.SPECIAL20
MED Severity
IRSCLAIMSA1.SA150
All Other Severity
IRSCLAIMSA1.SA153

CODE TYPE:
{IRSCODE_FallSeverity.CODE_TYPE} = “98”
{IRSCODE_MedSeverity.CODE_TYPE} = “100081“
{IRSCODE_AllOtherSeverity.CODE_TYPE} } = “100084”

Linked:
IRSCLAIM.CLAIM --> IRSCLAIMSA1.CLAIM
IRSCLAIM.SPECIAL20 --> IRSCODE_FallSeverity.CODE
IRSCLAIMSA1.SA150 --> IRSCODE_MedSeverity.CODE
IRSCLAIMSA1.SA153 --> IRSCODE_AllOtherSeverity.CODE

Crystal XI


Thank you!

 

[lbass]

I'm a little confused. Are the IRSCODE tables all aliases of the same table IRSCODE? If so, it appears that this table includes field: CODE and CODE_TYPE. What does the CODE field look like? Is there another field that shows the description? Please show samples of the values that appear for each of the following:

{IRSCODE.CODE}
{IRSCODE.CODE_TYPE}
{IRSCLAIM.CLAIM}
{IRSCLAIM.SPECIAL20}
{IRSCLAIMSA1.SA150}
{IRSCLAIMSA1.SA153}

-LB

 

[jschill2628]

See attached (flicker pic)

The code table is just that a table filled with hundreds of codes: 00, 01, 02, etc.

The code type defines the field we want to pull certain code descriptions from, so if we want to pull the Fall severity descriptions from the code table we connect the code table to the claim table , and type in the selection criteria the code type. Code type example, we have hundreds of code types to go with our hundreds of fields. These can range from 8, 19, 56, 100081, etc.

http://www.flickr.com/photos/30812012@N04/5739381869/

I hope this helps.

Thank you!

 

[lbass]

This does not respond to my request.

-LB