MySQL Forums
Forum List  »  Microsoft Access

Cascade Error?
Posted by: Jonathan Burkholder
Date: April 21, 2014 08:12AM

I implemented a half-year long project today for a total work system from entry to completion for my employer. I converted our current access MDB file to a MySQL dump file and uploaded it to the server with no issues.

The Issue:

We have work orders and on the work orders screen (in the MS Access Front End), each work order has a subform with multiple notes in it, there is a relationship between the main form and the subform which links the Work Order number of the main form with the work order number saved to the subform. One user adds a note and that note cascades to every single new note created. It looks like either MS Access of the MySQL server is just duplicating that one work order number.

Any suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Cascade Error?
3102
April 21, 2014 08:12AM
1579
April 21, 2014 09:25AM
1500
April 21, 2014 09:31AM
1546
April 21, 2014 03:57PM
1643
April 28, 2014 08:56AM
1475
April 28, 2014 09:21AM
1488
April 28, 2014 10:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.