[BCMA] Combined database for archives and artefacts

[Moderated BCMA subscriber listserv.]

Moderated BCMA subscriber listserv. wrote:
> Hi,
>
> I was wondering if anybody has a collections database that combines 
> archival and artefact records in one layout? And if so does it work 
> well for you?
>
Barkerville has an Access database that has separate tables for Archives 
and Objects (and many other information sources). There are all, 
however, linked by a single common "Subject term" table - all data 
sources contribute to this table. That way one search in "Subject Terms" 
brings up records in any data source (objects, archives, library, maps, 
genealogical...). This was an idea for linking Archives and Museum data 
that Bill Purver of the Archives Association of BC suggested many years 
ago while I was working at the BCMA.

You can see this in action (an online version) at 
http://collections.barkerville.ca/

Cliff
> Thanks,
>
> Alexis Jensen
> ajensen at nikkeiplace.org
> -- 
> Alexis Jensen
>
> Collecions Manager
> Japanese Canadian National Museum
> 604 777 7000 ext 140
> ------------------------------------------------------------------------
>
> _______________________________________________
> BCMA mailing list
> BCMA at lists.vvv.com
> http://lists.vvv.com/mailman/listinfo/bcma
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vvv.com/pipermail/bcma/attachments/20100128/c01d39cc/attachment-0001.htm