Dear Lee,
In our current Access 97 HER database, we imported the list of preferred
terms from the Welsh Thesaurus into a separate table linked to the main HER
table as a 'combo box' drop-down list and added an extra control so that a
term could not be entered in the field if it was not included in the list.
Although we had fewer terms when we added the list (nearly 2200) there
didn't seem to be a problem with the functionality. We didn't take into
account the hierarchy, as this could be checked elsewhere.
I hope that might help?
Best wishes,
Nina
---------------------------------------------------------------------
Nina Steele
Historic Environment Record Archaeologist
Gwynedd Archaeological Trust
Craig Beuno
Garth Road
Bangor
Gwynedd
LL57 2RT
01248 352535 (ffon/phone)
01248 370925 (ffacs/fax)
website: www.heneb.co.uk
email: [log in to unmask]
The Gwynedd Regional Historic Environment Record (HER) covers the old
counties of Caernarvonshire, Merionethshire, and Anglesey (now the unitary
authorities of Gwynedd, Ynys Môn, and the western part of Sir Conwy).
The HER comprises a database of known archaeological sites within this area
supported by digital mapping. The archive holds a collection of paper
records relating to these, including maps and archaeological reports. There
is also a reference library containing a large number of books and journals.
The HER is open to the public during normal office hours, but we would
request that people wishing to consult the records book an appointment
beforehand.
The Historic Environment Record was formerly known as the Sites and
Monuments Record.
|