Thanks so much!

Thanks for the reply. Looking at my example again, I thought I had a poor one so I will do another.

Table1

ID#TypeName#Type

-------------------

1#Maths#Subject

2#Science#Subject

3#Percent10#Percentile

4#Percent50#Percentile

Using Table 1, I would need to write a script...