This is just sharing knowledge around an interesting requirement.

One of our clients had a requirement of creating two data-tables mapped in to two different data classes along with two database table instances.

Example,

ABC-Ent-Data-CaseTypes (Table Name: PegaDataTypes [Columns- CASETYPE and DESCRIPTION])

ABC-Ent-Data-SubCaseTypes (Table Name: PegaDataSubTypes [Columns- CASETYPE, SUBCASETYPE, DESCRIPTION])

Client wanted to bring all the data in CASETYPE from ABC-Ent-Data-CaseTypes as an auto-complete under ABC-Ent-Data-SubCaseTypes CASETYPE. This prevents typo and re-entering same data to second table. Please note that; the requirement is bit bigger than how it explain in this post but just wanted to keep it simple for understanding purpose.

There could be many ways to do this; but the approach what we followed is very simple.

Set CASETYPE as the key under ABC-Ent-Data-CaseTypes class. Change UI Control of CASETYPE under

ABC-Ent-Data-SubCaseTypes to OpenRuleAdvancealong by setting up parameters as Class = ABC-Ent-Data-CaseTypes and ApplyTo = . CASETYPE.

This queries the data from PegaDataTypes instead of running it through a data-page or report-definition.