Saturday, December 10, 2011

Dynamic View

PAGE Design




Create the work record : NM_STATE_WRK
Add two field COUNTRY, STATE




Create the Dynamic view : NM_STATE_DVW
Add two field STATE , Desc



Create the Component : ZM_STATE_COMP and add the page ZM_STATE_PG

On Component Record Field : COUNTRY write the following piece of CODE to populate STATE field value dynamically based on COUNTRY field selected.





SQLText : Is the property of Dynamic VW which assing to field value of record as show below....

NM_STATE_WRK.STATE.SqlText = &SQLString

No comments: