So if I get it right, you need 3rd table for event id and event name and then a 4th table for connections because 1 ship can have multiple events connected to it and each ship/event pair has 0 or 1 port connected to it.

And then you just left join the connection table to the other 3 tables to get all the information back.

There is probably a docking event (don't see it on that image though), so you need to join all the 3 tables, list only the lines with that specific event and order by dock name and then ship name.

This post was edited by Cyberbeni on Nov 24 2015 04:18am

I think i was overcomplicating things. I created a table with the 2 primary key as one ( composite key).

Inserted the values from the table (portid, ship number)

The third table I've created will allow me to use the select join method between the 2 tables



This post was edited by Chesse on Nov 24 2015 12:49pm

Hello Cheese

I can give an example of Many to Many relationships

Many to Many

How many Students can teachers have? Many
how many teachers can students have? Many


Join Method:

When looking at what your provided for us to use as the example. We need to table because we do not want to keep typing the same name out over and over. This allows use to create a drop down menu when inserting a new row.

thanks for clarifying, I understand the concept now.

Is anyone here good with E-R diagrams and could possibly look over my model?
I can give out my remaining fg if anyone is interested

Post it.

I am still working on the multiplicities, relationships, and attributes. I would also rather pm the person who is interested to avoid any possible conflicts