Hello All,
I would like to place a list of countries in Field A so that when I select say USA the currency amount in field B should show a "$" sign and when I select South Africa in Field A the currency amount in field B should display a "R" currency symbol etc. How does one do that. I have tried using the format command without success.
I would like to place a list of countries in Field A so that when I select say USA the currency amount in field B should show a "$" sign and when I select South Africa in Field A the currency amount in field B should display a "R" currency symbol etc. How does one do that. I have tried using the format command without success.
Last edited:
