Populate a table field based on another field in the same table

[Former Member]

Hi,

I have a table with fields collection profile and collection prfile text. When maintaining this table, the collection profile name should appear automatically ( from table UDM_COLL_GRPT) based on the collection profile entered.. In UDM_COLL_GRPT, collection profilr name is not a primary key. Please let me know how to do this.

Thanks in advance,

Jissa

[Former Member]

Guess you could make use of the event 05 from the TMG events to make the appropriate selections and populate the field.

Vikranth