looking to do currency conversions in the database. What I want to do is to have a separate currency table which then, depending on which currency is selected in the main database, converts the input data into local currency.
In other rdb's or excel I would use another data table or a vlookup function. How do I do it in Approach?
Any ideas welcome.