Thanks Jason,
I always thought you had to create relationships in mysql and in the application. Thanks for clarifying this issue for me as it has confused me for a while. The reason it confused me is because when you look at the same database in microsoft access (relational data view) it shows you the table relationships are already established (the ones you described in your first post). However in mysql there is no ui that shows you the relational data.