Additional info connected to ADDRESS FIELD

Hi there,

I'm building an app in which i will create a table for all global locations (about 5000)
I like to use the address field for this purpose.
We cannot add fields inside the  ADDRESS field itself

However I would like to add automatically more country (and perhaps even city) specific information into my tables using the location's address field details.

For example I was thinking to create a table COUNTRYDETAILS that contains info like the TLD codes, The international telephone access code, The currency, A contact person, A selected provider, electrical power socket model, emergency telephone numbers  etc etc..

So when I'm looking at a form with details for a site in Germany I can also see that that the TLD-code is DE, i need to dial +43, their currency is EURO, that Germany has 230V and power socket model 'SHUKO',  etc etc.

Eventually I also like to pass and use this info further into the app in a purchase process where it will help to auto pre-select the correct currency and the correct country provider and present the applicable purchase items for a location center in that country (or city).

Thanks for your suggestions,

Jan-Willem

------------------------------
Jan-Willem Jan-Willem
------------------------------