Help with form selections

[mmcginley]

I've set up a form where i choose a country in one drop down box and this choice selects the exchange rate i get in another drop down menu. The exchange rates are controlled by a linked spreadsheet which automatically updates my database with the latest information. However, on my spreadsheet every country which uses the euro is grouped into one name 'euroland'. In my country drop down box though, are the individual names, france, germany etc. I cannot alter the spreadsheet as it is used by many people in the organisation. What i need to do then, it get my database to recognise all the European countries as 'Euroland', while still keeping the discreet names in my drop down menu.

Any help appreciated

If anyone needs me to clarify anything just ask

 

[elbweb]

ok so wa front end where they can choose a country, and then your data base returns an amount (currency) and you want to change they type of currency you return (i.e. euros of dollars) based on the country.

but you want to do this without any code changes on the acctual form?

maybe for me to understand it right you could post an empty version of your db, or something like that, so we can play around with that and see exactly what you are talking about?

 

[pbaldy]

A combo can have 2 columns, one of which could be the value to be used for this purpose. It can be hidden.