1.
|
Using the Forms Editor, set up the following forms:
|
|
Create a form to hold a custom Text - Single-Line attribute, Originating Project.
|
1.
|
In the Forms Editor, set up two forms, both using the same database table.
|
6.
|
create view proj_mos_by_proj_code (
asscProj, MOName, ProjID, mo_id, comp_type_name) As
select PROJ.name as asscProj, MO.name as MOName,
PROJ.project_id as ProjID, MO.mktg_object_id as mo_id,
MO.comp_type_name as comp_type_name
from uap_projects PROJ, dyn_mo_table MOT, uap_mktgobject MO
where PROJ.proj_code = MOT.PID and MOT.po_id = MO.mktg_object_id
Copyright IBM Corporation 2014. All Rights Reserved.
|