Selecting different currency

[Kyriakos]

Hi to everyone. I have this form that my let's say clients should fill in. In one drop down list I need the client to be able to choose different currency i.e. euros or pounds or dollars. But I need the symbol to appear in the list and since the field is currency type I can't use the lookup wizard to decide what values should appear in that list.

How is this possible? Should I make an extra field of text type to choose the currency and on another field of number type to place the value I need or is there another way?

Hope I am cleaar enough...

Kyriakos

 

[Rod D]

Hi Kyriakos

In my opinion, you will need to have an extra text field to hold the currency type. This is because once you leave the record, there will be no way of knowing what was set when you come to edit it later, or use in a report.

You can use this text field to format the value field as well if you want.

Regards
Rod