According to the description in your post, this kind of relationship is possible

You should explain what kind of error SQL is giving you when you try and "save" these tables...