Hi All, I have for orders form where I can select the currency, USD, EUR, ZAR... from a combo box, I want the currency selected to show in my orders detail when entering the cost of the unit. any idea how to accomplish this?
you need a tCurrency table with all the denoms.
set the source of the combo to this table, you can also set the default to USD if needed.
set the target of the combo to the field in the OrderDetail table.