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_nofrom vs_eaddress ejoin tr_eaddress_type et on e.eaddress_type = et.idwhere e.customer_no = :customer_noand 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
Let me add that I want this dropdown only to populate based on an email no and I am guessing that is the reason for the prompt?
I also saw a post similar to this but there was no difinitive answer.