From: Michael Dykman Date: March 24 2012 4:09am Subject: Re: OT: SQL Question List-Archive: http://lists.mysql.com/mysql/227032 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable A many-to-many is generally best accomplished with a third linking table which contains the ids of the 2 records being linked ie. create table tflink ( flightid int; teacherid int; ); On Fri, Mar 23, 2012 at 10:28 PM, Mark Phillips wrote: > My question is not specific to MySQL, even though I am using a MySQL db f= or > this project. I have a servlet/jsp/MySQL web site in production, and ther= e > are about 2,000 records in the flights table. One of the foreign keys is > teacher_id. Up to this point, there is a one to many relationship between > teacher_id and the data in the flights table. I need to change the data > model to allow for a many to many relationship between teacher_id and the > data in the flight table. What is the best way to do this? > > Thanks, > > Mark --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.