Ok, I have two tables on a MySQL backend linked through ODBC and a form and a query on the frontend (ACCESS). The query is set up to show both tables, linked through the phone numbers on each table and then the fields added to the query so they link on the form.
I have done this multiple times with other forms, queries and tables in the same database and all have worked correctly. But for some reason this form this time, while setting it up the same way, when I open the form, and go to edit the data on the form, which goes through the query and then to the linked ODBC tables, I can't edit anything on the form and it says "This Recordset Is Not Updateable" in the lower left hand corner of ACCESS.
Does anyone have any ideas with this problem?
Thanks in advance.