So if Mr X registered with my site and said "please inform me if a job with the word 'developer' in it's title comes up on your job database" then an email would be sent to him with the details held on that vacancy in the database?

BTW this is an Access DB.

Thanks for your help.

NB. Everyone in England is thinking about you guys Stateside today.

------------------
***born to be wild***

There would obviously be several scripts involved and would probably only be sufficient for relatively small DB's - I'm estimating no more than 5000 records or it would probably timeout. Also, you'd probably want to restrict titles to no more than 5 words.

Logic:

1. Check each word in title (eliminating 'the', 'and', 'a', etc.) for match.

2a. Return matches for word 1.
2a.1. Send e-mails
2b. Return Matches for word 2.

...etc.

At least that's the way I would apporoach it. My first task would be to get the DB to return results on first title word. Second task would be to send emails. Third task would be to loop thru title words.

Does this make sense???

Anyone have a url of a tutorial or something that may get me started?

Cheers...

------------------
***born to be wild***

If you really want to do it from within Access as an event (which I do not recommend) try this post from an Access forum:

http://knebel.net/msaccess/_access_discuss/000000e0.htm

I'm happy to take your recommendation that I don't use the "On update" bit of Access, but....

"You should be able to get the form / page / script doing the Add / Update to pass to the next script to check for keyword matches, shouldn't you"

I think this is my problem! I don't really understand what you mean!

Maybe I'm too newbie for this!! I can use ACCESS as a user, and I can use FP2000 and the FP DRW and a bit of ASP, but I don't know what you mean by script. It is JavaScript? And where would I put it?

I know I sound really thick about this. But 12 months ago I couldn't understand HTML and I'm creating webs happily enough today...

Any advice/articles I should read would be welcome...

------------------
***born to be wild***

OK - here goes....

I will assume that you are already posting your results to the DB and are using the DRW. Once you have posted, after the DRW (or ASP / SQL code to post the record), I would put a redirect to send parameters to a second page. Something like:

<%Response.Redirect "http://www.mydomain.com/titleMatchEmailer.asp?=" & FP_FieldVal(fp_rs,"jobTitle")%>

(substitute your values - http and field names - for mine) Then on 'titleMatchEmailer.asp' (or whatever your second page is called, I'd do something like this:

<%
Dim titleStr
titleStr = Request.Querystring("jobTitle")%>

to grab the Job Title. Then disect the Job Title into individual words. I would replace spaces with commas then use SQL's 'SPLIT' function and search your DB for people using any of those words for their 'keywords'.

Then, (still on 'titleMatchEmailer.asp' or whatever you called that page) I would email to each of those in the results of that query. I use CDONTS but you may not be. Check with your host....

Lastly, I would redirect that page AFTER emailing to your confirmation page that is viewed by the user entering the job description.

All of those pieces should be able to be tackled (and troubleshoot) one at a time and I would treat them individually as modules.

I hope this helps.