I assume you are trying to report on the customer email field.
email_hdw on the customer table needs to link to notekey_hdw on the cusemail_hdw table and you can then report on notetext_hdw to get the email address.
That answers part of it - thank you!
I also have the same issue with the following fields CUSPERS_HDW.EMAIL_HDW and OPERTR_HDW.EMAIL_HDW.
Please can you help?
cuspers_hdw.email_hdw links to cpremail_hdw.notekey_hdw
opertr_hdw.email_hdw links to opermail_hdw.notekey_hdw
Hope that helps
1 of 1 people found this helpful
The following article explains how to report on Note fields (elements created as type Note in Designer) in Helpdesk. The email fields are usually Note type fields in Helpdesk.
Many thanks Nick and Martyn.
Am very now!