thx for reply
current coppermine database has a one (album) to many (image) relationship
having a pre defined admin only settable group of keywords improves the integrity of any database - less keywords = better searches
but this would require a one (image) to many (keywords) relationship
eg.
image in "Home\Holidays\2005\Greece" that is say a picture of you lying on the beach could have keywords "beach, people, friends"
would require 2 new tables - one for keywords and a join table to image database
advantages = when searching as well as having free text, and drop down list could make available keywords used to help refine searches
cheers again
rick