I have an MS access system that i need to update a Mysql System when the access table is saved. The Mysql Database will never update the Access Database only the Access Database Must update the Mysql Database.
In both databases i have a field PRODUCT_CODE and PARENT_PRODUCT_CODE
If they exist, they must be updated,
If they do not exist they must be added ONLY if they contain a value in a specific column(PARENT_PRODUCT_CODE)