Error connecting to ODBC mySQL database
I'm trying to set up a system where I use FMP to connect to my web stores live mySQL database (remote server). I want to add inventory in the shop with a scanner and be able to run reports easier.
I have had issues at each step but have been able to get it sorted. I have my ip added for full privileges on the mySQL remote server. I have the ODBC drivers installed. I want to link to a table called "Products" from the remote database. When I enter manage-database-relationships and click add table I see my table and select it. Next I see my tables in the remote data base. When I select "products" or any table I get:
"This action cannot be performed because the required table is missing."
Can anyone help me with this? I'm new to file maker pro but have some database experience.