Hi,

I have two databases, one which shows an individual's cancer record and another related databases which contains a list of all cancer types.

The user can lookup which type of cancer someone has had via conditional value lists related to fields in the second database. There are three types of information

in the cancer type database, the main group of cancer type, a more detailed sub group and their own unique disease code. Many users on my system will not know

what main group of cancer to look in to display the sub-group's value list. I want the user to be able to enter basic a basic search string in the individual cancer

record and have this searched for in the cancer type database. I want this to search in the sub-group field and display a concantenation of the main and sub group

back in the individual cancer record so that the user may refer to this to aid their data entry, there could be many (30-50) concantenated options that would need

to be displayed.

Anyone got any tips on how to proceed with this?

Thanks

Are you still stuck with this ?

I think the keypoint would be to elaborate on "Many users on my system will not know what main group of cancer to look in to display the sub-group's value list."

This is obviously the startpoint of any conditional value list. Or let them enter some keywords and have a portal display the result for the keyword entered as in a Type-Ahead portal.

HTH