Hello, I'm brand new to MySQL and MySQLCC. I've been able to create the
database and tables just fine, but I have the need to have Fields that occur in
one table also show up in other tables. For example : Mary has 1 route John has 2 route Phyliss has 3 routes. I have a table within database a that has a address book of all carriers. I
have another table that has a list of all routes. No two carriers can have the
same route, but a carrier my have more then one route. I want the carrier table
to contain all of the routes that this carrier has and the route table to know
if the route is taken by a particular carrier so that when the carrier is
terminated the route available date field will populate. Or when the route
available date is non-null then it is available. Any guidance on this will be
appreciated.

Troy I tried the F1 help function but its greyed out.