Help setting up form/database management

Hi, very novice user here. I am trying to set up a for to make an entry in a database, while at the same time notifying users in a second database, via email, that a new entry has been made. I want the data entered by the form to generate a unique link in the email that the end users can refer back to. I also need to sort the entries by state, i.e. if the form entry specifies it has information for states A and B but not C, only endusers in states A and B recieve the notification. Any suggestions or pointers on how to accomplish this?

Hi roguediamond,

this needs some PHP scripting and maybe the use of ChronoConnectivity too and some plan written, and it depends on your form data..etc, not easy to tell in a quick response here, sorry!

Regards,
Max