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.
Have no knowledge, have some links