lookup in smmactivity


I added a field, name “activity_code” in smmactivities unlike activity number field it is not unique but i want to have a lookup like in activity number. Is there any one can help me how to lookup my activity code I am newbie about this and trying to follow the format of activity number but i failed.

scenario: in hour journal i want to have a drop down list activity code base on project. same lookup in activity number. thanks

best regards,


Hi Raphael,

See whether this helps - http://www.axaptapedia.com/Lookups AND http://www.axaptapedia.com/SysTableLookup_class

Also search for ‘lookup’ in Developers guide.

Best wishes,