How to defined relations inside MySQL.
I need a simple way to define relations, like in Access.

I built a database under Access, then import into MySQL,
but relations are lost.
How to rebuild them ?

Thanks for help.
Pierre.

elation: Strong feelings of exhilaration, euphoria and optimism.

Sorry...I couldn't resist...

Anyways Pierre, you'll need to be more specific with your problem if you want help. What kind of problems are you having? What are your errors? What are you doing to get these errors? etc. etc. etc.

(Also, why are you designing in Access and then importing?)

I do not have any errors.
Just, after importing an Access database into MySQL through
MySQL-front software, all tables are there, no errors, successful,
but the relations betwen tables are lost.
No more relations, I need to rebuild them.

Under Access I define my relations between tables,
example : When deleting a record in table 1, all related records in tables 2 will be automatically deleted too.

Hope , this is more clear ?

Thanks for help.
Pierre.

first off does your version of MySQL support realtionships - not all versions do, Version 3.xx I don't think does, V5 does, not sure where realtionships became part of MySQL

next does the tool you used to migrate from Access to MySQL support realtionships, and was the support optional - dbtools (for one) allows selection of options.