We're starting an Access project to x-reference contents
of a major collection of golf related artifacts - books,
photos, audio, equipment, etc. If such a system exists
we'd really appreciate hearing about it.
Nothing like getting a running start.
Dave, did you get my reply yesterday? Recopied below.
I'm sending this by EMail in case you or I are having posting trouble;
but please bear in mind that newsgroups are for the public, and are
free; private EMail support is for paying clients, and is not. Please
reply in the newsgroup so others can benefit and so that you can
benefit from the ideas of other volunteers!
John W. Vinson[MVP]
Yesterday's answer (reposted):
I very much doubt it - and it's not all that likely that the owner of
it would check this newsgroup every day if they did.
However, it would not be all that big a project in Access. It would
help to know what kind of information you're cross-referencing, but I
can imagine starting with a simple four-table database:
Artifacts
ArtifactID Autonumber Primary Key
Description Text (or Memo)
Category Text <filled from Categories using a combo box on a form>
<other information, e.g. storage location, acquisition date,
curatorID, ... depending on your needs>
Categories
Category Text Primary Key <e.g. "Book", "Photo", ...
Keywords
Keyword Text Primary Key
ArtifactKeywords
ArtifactID Long Integer <link to Artifacts>
Keyword Text <joint two-field Primary Key>
This could become much more elaborate or stay simple as your needs
require.
John W. Vinson[MVP]
