I am using a mysql linked table in an MS Access Front End.
There are 4 columns not including the ID PK, NOT NULL, auto increment column that are set to Not Null
When i open a blank form for entry the ID column is as expected blank, when I enter the four columns above I expect the ID column to be populated. Instead all form text boxes display "deleted".
However when I search for the record using the above 4 columns as search the record is there with an ID assigned.
Any ideas why it is crashing like this?