The strange thing is that I always make sure that AID gets a legitimate value during the add new record state. When they do appear, I will look into the query results and find a value of zero (0) entered into AID. Sometimes these messages don't appear at all. Sometimes, an error message pops up saying that 'Another user has edited this record before' or 'The update is not possible due to a duplicate key value'. However, adding records sometimes produce unpredictable results. Whenever I update the query by inputting a value for AID, that same value will be automatically placed on BID (both keys have to be present on the query definition). I made a query in Access that links both tables via these keys.

I have been using Access 2003 paired with MySQL and have found out that I can perform cascading inserts that are not possible in Navicat or other GUI-related MySQL database designers/editors.įor example, table A with primary key AID is the main table while table B is a related table with foreign key BID.

Navicat 2003