database to catalogue a collection

[elf21]

I'd like to create a database that will keep track of my photos collection. I would like to "tag" each photograph with several keywords then be able to perform a search by keywords to retrieve all related photographs.

What is the best way to go about this?
Thank you.

 

[dhookom]

I would expect you to have a table of photos with a primary key named something like "PhotoID". You could then create a related table with two fields:
tblPhotoKeyWords
==================
PhotoID
KeyWord

You can use a subform on your main photo form to display and link the KeyWords.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]