Database Design Help

[kurtsimons]

I need to create a database for an inhouse graphics search engine.

I need help difining my tables.

what do i do

1 table with the graphic names and locations and an ID

and

1 table with the keywords that relate back to the ID

but how do I execute a query and figure out what match is closer.

for example if the search word is part of the keyword it get less of a "match value" than if it was the whole word

any help would be great
if you have a diagram
email it to me [email protected]

thanks

[Lee M.]

Kind of a stretch, but...

For the keyword, I would use the Instring function, to return the number of times a group of letters appear in the title of the string. Then apply a variable to the return number. If the return number is greater than....(whatever) then the odds increase. If the word is only so long, and the letters appear in most of the places, then the odds are it will be the right choice.

Other than that, I have no clue!
Lee