I thought I saw an example of this somewhere but can't find it.
I want to be able to pull service order info from our business app into outlook tasks but the app stores the customer name info in a different table than the service order header table.
Can I set up a SQL query or something to match the customer number from the service order header table to the customer number in the customer table and pull the customers names into outlook tasks while loading service orders into outlook tasks?
is there an example of this type thing somewhere?
thank you,
matthew