[BiO BB] database design question

[Rowland, John G A]

I am currently in the process of building a small database in MS Access for the purposes of storing (in a computationally searchable format) protocol and results data from published and unpublished material.

I would like to be able to search this database for a particular gene/protein and see all instances of its occurrence, regardless of the use of synonyms and not restrictiong it to only pulling out a specific Accession number.

Unfortunately I am unsure of the best table/relationship setup to acheive this!

Can anyone offer any insight into this problem? (I have googled and googled for about 6 months...)

Regards,

John
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2613 bytes
Desc: not available
URL: <http://www.bioinformatics.org/pipermail/bbb/attachments/20040221/2ac863bb/attachment.bin>