Auto generate Meta Keywords

[bobthedog]

This might be of use to those of us who are managing websites with our Filemaker database.

I have a database with about 1000 records in it, each one a unique keyword in my niche.

I have another database which represents my webpages with one record being one page. Each page has the fields "Content" and "Meta Keywords".

Could anyone point me in the right direction to compare the "Content" field against the keyword database and each time a keyword is found in "Content", it gets added to the "Meta Keywords" field (separated by a comma).

Just a point in the general correct direction would be appreciated! :(