Thanks, it seems that my main problem was the DBH once I sorted that the rest helped its self, the $ needed to be replaced with ? and you are quite right about the whatever delete but I have used other constraints. Thank you it is always something so simple and obvious to everyone else isnt it? I get word blind.! Chris