Custom Screen

Hi

I have a custom tab that is for the most part working, howver I am having one issue with a dropdown field.. The followintg SQL is contained within the ddw object.

select  e.eaddress_no, email= e.address, e.primary_ind,customer_no
from vs_eaddress e
join tr_eaddress_type et on e.eaddress_type = et.id
where e.customer_no = :customer_no
and e.inactive = 'N'
and e.mail_purposes like '%1%'
order by primary_ind desc, address asc

I have several dropdowns on the screen thar arent giving me a problem.  However, this one (for emails) consistently prompts me for a customer no (the prompt is not checked on the obj).  I tried rebuilding the object, using different data fields, nothing is working and yet it seems to be set up like my others. 

At this point I do not know what else to do.

Any suggetstions would help!

Thanks in advance

Joe

Parents Reply Children
No Data