Hi all,

Before I complete the rest of my ERM can someone quickly check Im on the right path with the relationship and notation found at:

http://www.gcox.info/notation.jpg

If im right it should read as follows:

- A Coach driver will only be in the COACH_DRIVER table once and MAY have an entry in COACH_BOOKING zero or many times
- Zero or Many COACH_BOOKING must have a COACH_DRIVER

Thanks in advance !

P.S. The software Im using doesnt allow for dotted lines hence the use of circle notation on Coach Driver

Greg

Download a copy of DBDesigner (free) and give it another shot.