>Dear Hilmar,
>Yesterday I was looking at the database design which and I agreed with about it was a very bad database design
OK. As mentioned in my article and message, each subject would usually go into a separate record. This makes it much easier to search for an individual subject, sort by subject, filter by subject, count totals by subject, etc.
If you need additional advice about table structures, please ask back.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)