yes... do look for the possibility that when designing databases, the physical model doesn't necessary follow from the logical model...
in some cases, a mapping/relation/linking table (as shown by Pat) is necessary in the physical model [to fulfill the relation requirements in the logical model]
cheers!