What you are trying to do is beyond simple "wizard" steps
- you need to learn how to hand code ASP
Start here
http://www.w3schools.com/asp/default.asp
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________
"annaMac" <(E-Mail Removed)> wrote in message news:0FE848DD-4141-426B-B689-(E-Mail Removed)...
| Thank you stefan, it's a little tecnical for me, so perhaps you could spell
| it out in simple fashion - I have tried to simplify matteras as your
| suggestion so now have two tables in the one database both with the identical
| 'House' field. so I want to match when house in usertable matches house in
| clienttable.
|
| Thanks, anna.
|
| "Stefan B Rusynko" wrote:
|
| > You will need to hand code it to "save" the results of the 1st DB query (users="House") for use in the sendmail
| > - in a temp table or variables (like an ASP array)
| > Or nest (in a Do Loop) a second DB (users) open, find, send mail, close DB inside of each result of the 1st query (clients)
| >
| > PS
| > You really shouldn't have 2 DB, but 1 DB w/ 2 tables in it (users & clients) linked by a common relationship identical field
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
| > _____________________________________________
| >
| >
| > "annaMac" <(E-Mail Removed)> wrote in message news:64FADB6C-0095-4A81-AE35-(E-Mail Removed)...
| > | Hi Group.
| > |
| > | Hope you can help me again. I have a form which when submitted fires of a
| > | message to everyone in my userdatabase. (so that they know there is a new
| > | item on the website).
| > |
| > | I would like to be more selective now and sent it only to users that meet
| > | certain criteria depending on the form input. (The form submits to a
| > | clientdatabase).
| > |
| > | So, if the input form has a field: Type = "House" then I only want to send
| > | it to users with a field: Requirement = "House" and this then fires off a
| > | cdonts script to send the message.
| > |
| > | Ok, so far? - so my question is, How do I make this connection between the
| > | two databases? Appreciate your help in easy to understand steps as I still do
| > | not fully grasp what I am doing! Anna.
| > |
| > |
| >
| >
| >
Similar Threads
