For a management report I need to pull the user ID of both the person who posted a credit against an invoice and the user who created the sales order. I have linked back from the credit to the invoice, but since the invoice and the sales order are in the same table I am have troubles going backwards to the sales order to pull the user ID. I am using Crystal reports to gather this data.
Patrick
*This post is locked for comments