chetah, I'm sure you've figured it out already and i might be a bit too late in replying but it's important for you to know that for a relationship database to work you need to create one-to-many relationships throughout your database.

All one-to-one relationships must be combined and all many-to-many relationships need to be broken down.

Good Luck, Rushy