This is my first experience with the task I've been given, I've never had to integrate an FM database to an outside source this way.
What the goal of the project is to provide a web page (www.webpage.com) where a customer can login via username & password and be taken to a page where they can refer a friend to our company.
It just needs to be basic contact information, and then hit submit and that data needs to be entered into a table (Table A) in the FileMaker 14 database.
Once that person is submitted by the referring customer, it needs to send along with the referral's information the primary key of the customer who submitted them so that it can be tracked and filemaker can push back to the portal so the customer can see what happened with the person they referred to us.
What is the best technology to use for this, ODBC, ESS or CWP?
I figured I would setup a PHP/MySQL website for that, and have it connect to FM somehow, but I'm not sure what the best way to go about this is.