Thank you all for your valuable input it has really given me a lot to think about especially in terms of the different ways it can be done, will also give the SQL way a try thanks again!