Hi kevin,

>>I suspect this is one of the pitfalls people could fall in when it seems difficult to get your data in a form that is directly usable in your front end, but this is really bad, bad practise.
>
>I'll rephrase that, the Database was designed badly and with useless naming conventions etc. and in some cases does not follow normalisation rules.
>
>What I meant is by today's standards the db could be looked at as a whole, because it's an old DB (12 years) it has had a lot of "crap" added to it with no regard as to how these alterations fit into the big picture.
>
>In other words, I would revisit the DB design as my chosen example DB is IMO fundamentally flawed in some areas.

O.K. that makes things clear.