Help with a cost calculator based on different options.

[Mchgh9]

Hi,

I am trying to compile a calculator based on a set of options selected by the user. I want to use validation to allow a list of 3 choices which then determines what further options are available.

This is the table.

	Area 1</SPAN>	Area 2</SPAN>	Area 3</SPAN>
	0-2 & TS</SPAN>	3-4 & Non-TS</SPAN>	0-2</SPAN>	3-4 Sometime TS at TS time</SPAN>	3-4 Sometime TS at Non-TS time</SPAN>	3-4 Non TS</SPAN>	SSS Streets</SPAN>	Non-SSS Strets</SPAN>
MAJOR PAA</SPAN>	£103.00</SPAN>	£63.00</SPAN>	105</SPAN>	105</SPAN>	70</SPAN>	60</SPAN>	105</SPAN>	75</SPAN>
MAJOR</SPAN>	£208.00</SPAN>	£108.00</SPAN>	240</SPAN>	240</SPAN>	170</SPAN>	110</SPAN>	-</SPAN>	-</SPAN>
STANDARD</SPAN>	£122.00</SPAN>	£63.00</SPAN>	130</SPAN>	130</SPAN>	90</SPAN>	40</SPAN>	130</SPAN>	0</SPAN>
MINOR</SPAN>	£61.00</SPAN>	£31.00</SPAN>	65</SPAN>	65</SPAN>	45</SPAN>	10</SPAN>	64</SPAN>	0</SPAN>
IMMEDIATE</SPAN>	£57.00</SPAN>	£28.00</SPAN>	60</SPAN>	60</SPAN>	30</SPAN>	10</SPAN>	60</SPAN>	0</SPAN>
PERMIT VARIATION</SPAN>	£45.00</SPAN>	£35.00</SPAN>	?</SPAN>	?</SPAN>	?</SPAN>	?</SPAN>	45</SPAN>	35</SPAN>
Mjor PA >10 days</SPAN>							240</SPAN>	150</SPAN>
Major PA 4-10 days</SPAN>							130</SPAN>	75</SPAN>
Major PA <4days</SPAN>							65</SPAN>	45</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL span=2><COL></COLGROUP>

As you can see, area 1 has 12 possible combinations 2x6. Area 2 4 x 5 and then Area 3 has 8x 2 combinations.

Basically, there is the initial question of what area from a dropdown, then whether it is Major, Minor, Standard etc and finally which column out of the possible options does it fall in.

Any help much appreciated.

Thanks

David