Jeff, I would use a join table, teacher_flights.
create table teacher_flights( teacher_id int(11) not null, flight_id int(11) not null, primary key(teacher_id, flight_id)); Dave >________________________________ > From: Mark Phillips <m...@phillipsmarketing.biz> >To: Mysql List <mysql@lists.mysql.com> >Sent: Friday, March 23, 2012 7:28 PM >Subject: OT: SQL Question > >My question is not specific to MySQL, even though I am using a MySQL db for >this project. I have a servlet/jsp/MySQL web site in production, and there >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 > > >
