To answer Paul's question - that's why I put the "essentially" in. We don't physically separate events and monuments but we do logically separate them. Thus they are both in the same database and in the same table which means that all the locational information etc can be stored in the same ancillary tables. However they are separated by being called something different (i.e. a field called record type). It all depends what you mean by separate - same table, same database, same room... As far as I can see it is the logical data model that matters not its physical implementation.
I carefully didn't mention sources which we don't uniquely number at all!
Chris Webster
Somerset Sites and Monuments Record
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|