GilbertB 0 Newbie Poster

I am building this database : http://imageshack.us/photo/my-images/217/diagramg.png/

I have a difficilty Regarding Renting.

Because in this system one can order either DVD Or Game.

Therefore how am i going to link the Game or/and the Dvd to the Rent table ?

Currently it does not work due to the fact that both IDs in the *Type database * have to be inserted. I cannot insert either DVD or Game ID.

Is there a solution how this can work ?

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.