MySQL Forums
Forum List  »  MySQL Workbench

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
298
April 17, 2017 12:52PM


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.