Assuming you linked properly, what you describe should have worked. Kind of hard to diagnose without being able to see what you have done.

An alternative to what you are doing is to go to Custom Office and add the e-mail address from ar_customer to the openSalesOrderWORK table. Then you have to go back to crystal and do a verify database on the report for the new UDF to show up. If you are not familiar with doing this, get your Sage Partner involved. He/she should be able to do that for you in a couple of minutes.

Thanks for the information. I am looking into the Custom Office solution since it looks to be the easiest answer. When I am in Crystal Reports with the modified report I get no sales orders, like database is empty. Is this a generated database that is only available at run time?

The work files are only populated when you run the associated report.

Most of the time using a UDF works, but on occasion you get situations where the system won't allow you to pull in the data you want so you have to add a table. Always go the UDF route first (as it will be more efficient) and the table route last.

Finally got the field assigned under Custom Office and added to the report. The email field is also in one of the SO tables, and with a little help from Sage Support it is now running. I just need to print the entire database field lists again so that I have a better map to everything.

Understanding Custom Office is going to be my next project for my "spare time"

and you were right, it was solved in just a couple minutes.