abhishek.shah
New Member
how do you store the all field labels of a table pj1_mstr in a temp-table ttable?
Sounds a bit of a nightmare to be honest.
Code:for each person no-lock, first projectmaster no-lock where projectmaster.pj1_delivery_resp eq person.person-key: end.
Do that for each of your fields and create a temp table record.
I want to create a dropdown of the employees who are either "Delivery owner","Invoice Owner","Account manager","Primary SalesPerson" of any project. Pls. note all the above are fields pj1_delivery_resp, pj1_invoice_resp, pj1_act_mgr, pj1_sp6 in projectMaster table i.e pj1_mstr which store employee code.
[FONT=courier new]FOR EACH Employee NO-LOCK
WHERE /* filter only active emp */ ,
EACH pj1_Mstr Of Employee NO-LOCK /* if this is possible*/
WHERE /* filter for records you want in your temp-table*/ :
CREATE Some_TempTable.
END.