Web form in PHP/MySQL to send data to FMP
Question -- how do I integrate this with FMP? In other words, how can automate the process, where either FMP connects to the MySQL database and imports all the data (on a daily basis, for example), or everything could be submitted to FMP via an export from MySQL? Any plugins and add-ons that help automate this basic and very needed task?
Second question would be the reverse of this, how can my computer's FMP "update" the MySQL database with the latest or corrected info, as well as any new purchase order that I might have done from information coming via phone, email, fax, in person?