[QUOTE]Originally posted by paulw
It's not knowing the code, it's knowing where to look
The word's of a wise progammer. I've now got an extensive library burned on a cd of all my code from previous contracts and it makes life so much more easier. and as i'm a web developer, no guessing what I do when I'm stumped.

[QUOTE]Originally posted by paulw
Normalisation is a great technique but it can lead to a lot of tables that you then have to stitch back together with Union queries which are not updatable.
Tell me about it. in one of my previous contracts, this guy designed the SQL Server the database and must of put in tables for just the sake of it (like a lookup table that only ever has two fields). I would have taken him outside if it wasn't for the fact that it was the bosses son.

as for getting back to london. I'm up here in manchester for another week or two , and I haven't got my new contract lined up yet. But i'm definatley trying to get back to working their as I haven't for a while and it's only 1 1/2 hours from where I live. will keep you informed when i'm back

Ian