Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    54

    Unanswered: Defining elations

    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.
    Pierre (Pl-Arts)

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297

    What is an elation?

    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?)

  3. #3
    Join Date
    Jan 2003
    Posts
    54

    More informations

    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.
    Pierre (Pl-Arts)

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •