Auto refresh external look up field
How to auto refresh external look up field when related field selection is updated. I have 3 external lookup field, one is fetching investments and another fetching product and the 3rd one fetching applicable currency related to the selected investment and product from a source. when I change the product manually, the currency still displays previous currency value, although there applicable currency on the dropdown. What steps to be followed, so that the currency is auto updated and previous currency value is auto refreshed when product is updated.