Create New Record Between 2 Database Files
Hi. So I am on FMP 11 Advanced & Server.
I have 2 database files on my server. 1 database file is called Questionnaire. With this file I have setup with the Site assistance Web page for a Questionnaire people can fill out online.
Then I have a 2nd database file on my server called PERSON that is for inner office use only and contains all the records of everyone who has submitted a questionnaire with us.
What I would like to do is anytime a new questionnaire is submitted online and a new record is created in the Questionnaire database with all the information entered in from the user, I would like to set it up that it automatically creates a new record in the PERSON database and enters in all the informtion for that new record. Any suggestions of how I can set this up?
Separate question: I also wanted to know if there is a way that once someone submits a new questionnaire online for me to tell the server software to send me a notification email either that a new record has been submitted OR what I would rather have it do is send me an email with all the information entered in by the user?
Another separate question: Is it possible for me to put in my own coding into the PHP files that were created from the Site Assistances setup for the Questionnaire online to have someone upload photos to the Questionnarie and have those photo's saved into my container fields in my questionnaire?
Okay I think that is all... thanks for your help!