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
>To: Mysql List
>Sent: Friday, March 23, 2012 7:28 PM
>
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
