Previously posted in wrong forum
Hi,
On the Edit form I want to do the following query and have the field displayed on the form :
select substr(rtrim(town_city)||' '||rtrim(suburb)||' '||rtrim(STREET_NO)||' '||rtrim(STREET_NAME)||' '||
rtrim(table_desc)||' '||rtrim(SHORT_DESC_2),1,200) Address,
decode(work_req_type,'DC','Credit','DP','Prepaid','ChangeOver') Method
from msf541 a, msf011 b, msf010 c
where a.request_id,' ') = da_number
and a.location = b.location(+)
and c.table_type = 'SLOC'
and c.table_Code = rtrim(street_position,' ');
How can I do this using the On event trigger ?
Thanks
