MySQL Forums :: MySQL Workbench :: Access Migration one to many relationship

Advanced Search

Access Migration one to many relationship
Posted by: Weldon Schultz ()
Date: April 17, 2017 12:52PM

I am new to MySQL. I have migrated an Access database to MySQL that is running on SME Server. I connected my Access Front End to MySQL through ODBC. That works fine, but through the migration (using MySQL Workbench and it did not give error messages) my subforms in Access are not working correctly. The way it's acting, in Access it would have been a bad 'one to many' relationship definition.

Example: Let's say I have an order form and there is a subform attached to that order that contains the products. All products show the same as the first row. What am I doing wrong?

Options: ReplyQuote

Subject Views Written By Posted
Access Migration one to many relationship 93 Weldon Schultz 04/17/2017 12:52PM

Sorry, only registered users may post in this forum.

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.