Home » Developer & Programmer » Designer » how to design table for m:m relationships?
how to design table for m:m relationships? [message #26044] Thu, 05 June 2003 03:06 Go to next message
Freeman
Messages: 1
Registered: June 2003
Junior Member
how to design table for m:m relationships?
for example:
there are some dramas and artists involved in the dramas, it means Artist_A may involve in Drama_A, Drama_B, Artist_B may involve in Drama_B, Drama_C;
Then Drama_B has two artists there.
How can I solve it??
Re: how to design table for m:m relationships? [message #26045 is a reply to message #26044] Thu, 05 June 2003 04:05 Go to previous message
amit zhankar
Messages: 31
Registered: March 2003
Member
Hi,

You can use this design

1. Drama Master
drama_code
drama_desc
2. Artist_master
artist_code
artist_desc
3. drama_artist_link ( Detail Table )
drama_code
artist_code

try this this can solve ur problem

amit
Previous Topic: API for Designer 6i
Next Topic: database design
Goto Forum:
  


Current Time: Mon Mar 18 23:35:09 CDT 2024