On Sat, 23 May 2015, Rob Willett wrote: > Thanks again and as its Saturday have a drink. If any of you are near York > in England I?ll happily buy you a pint.
Rob, I'm in the upper left corner of the US so I'll have to pass on your kind offer. Germane to your fundamental concern, over the years I've found that my first pass at a database schema is usually sub-optimal. The first design is based on initial assumptions, and further deep thinking can bring up issues not recognized before. I'm sure you will evolve a schema that works well for your needs and avoids hidden problems. Rich