For a custom lookup style column FX_Currency_RecID on the Sales Order form. The field will be populated by clicking the lookup button and selecting from currencies on the existing FX_Currency table. The existing form under System Settings > Foreign Exchange > Currencies will be used to maintain the list of foreign currencies for the sales order form.
The end result will look like this on the sales order form:
To create the lookup column, complete the following steps:
- Create a new C# Plugin called Demo FX Lookup on sales order
- Select custom fields tab and select Sales order row under the Modules grid. In the fields grid, enter the Name as FX_Currency_RecID and choose cell type of Lookup. Press Save.
