The best approach to achieve the outcome you need is to introduce a new column in the invoice table in the database, and to populate it with the type of the currency of the invoice. This way, when you retrieve the invoice objects, you will be able to format what is displayed in the grid as you need.
I hope this helps. If you have further Data Access related questions, do not hesitate to get back to us.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map