Thanks Uncle Gizmo, yes this is the result of a seriously overlooked factor, in an ideal world, I would have designed the database differently, but have learned a life long lesson. All tables are exactly the same structure, just named differently. Thanks very much indeed for your advice any...