Is an array the best option for me and if so how ?

[clive.churchward]

Good Morning

I am trying to set a comparison of shipping costs
possibly using a pick list and/or an array but I cant get my head
around all the different option

I want to be able to choose a county and this gives me the zones for
each carrier and from this it would calclate the
shipping cost for each carrier

I have created apicklist of every county in the world so I though
I next need to give each country a zone number whch if defferent for
every carrier

so if a choose Ireland I need the rules to show each code

ie

CARRIER = TNT CITY
UPS DHL
-------------------------------------------------------------------------------------------------------
IRELAND T1 C3
U6 D8


Any help would be must appreciated
Regards Clive

(e-mail address removed)

 

[MartinW]

Hi Clive,

Your scope is a bit too broad for the sort of advice
you will achieve here. Debra Dalgleish has covered
most, if not all, of the techniques you will require
at her Contextures site. Here is the link,
http://www.contextures.com/tiptech.html

The Data Validation techniques are probably the most relevant
to your needs, but I am sure there are a few others that
will come in handy.

Post back here to the newsgroups about more specific problems
as they crop up.

HTH
Martin