MySQL Forums
Forum List  »  Microsoft Access

foreign keys and relationship
Posted by: azzara taomatics
Date: February 20, 2010 12:50AM

I'm trying to use Access as a Mysql front end.
Reading some docs about mysql In the last days i've confused my ideas
about key, relations and joins.
Consider my Mysql db that has only four tables, so I need to show some
fields from these tables on an Access mask (i.e. clients and orders).
Have I only declair foreign keys on Mysql or is there any more to
do?
I've already tried some insert via Access and no errors came back.
I only desire to understand if, at server level, a foreign key
constraint between two tables is sufficient to preserv the
relationship integrity or there is some more else.
Thank you very much.

Options: ReplyQuote


Subject
Views
Written By
Posted
foreign keys and relationship
3058
February 20, 2010 12:50AM


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.