two child fields from one parent table relation

B

boaz

Hi,

I have 2 tables. One is a [Color] table. Another one is a [Mix] table.
The idea is to have a record of what colors are being mixed to make another
color.

In the [Color] table (parent):
I have one field "Color" as the primary key
Red
Green
Blue
Purple

In the [Mix] table (child)
I have the primary key with 2 fields -> Color + Color_Mixed
I have 2 records for: "Purple is mixed with Green and Blue"
Purple - Green
Purple - Blue

How do I create a relationship for both Color and Color_Mixed to point to
the only key field in the [Color] table?

I can only drag a "relationship" line from one table to another table. If I
drag another "relationship" line, Visio will give me an error.






--
 
B

boaz

Hi,

I have been thinking about this problem.

If I add an Auto Number to the [Mix] table, and make the "Color_Mixed" an
attribute instead of a primary key, will this make any difference...
logically, physcially, or biologically?

So the [Mix] table will look like:
1) Color (FK)
2) Counter (PK)
3) Color_Mixed (FK)

Instead of:
1) Color (FK)
2) Color_Mixed (FK)

Where 1) + 2) = Primary Key for the table


boaz said:
Hi,

I have 2 tables. One is a [Color] table. Another one is a [Mix] table.
The idea is to have a record of what colors are being mixed to make
another color.

In the [Color] table (parent):
I have one field "Color" as the primary key
Red
Green
Blue
Purple

In the [Mix] table (child)
I have the primary key with 2 fields -> Color + Color_Mixed
I have 2 records for: "Purple is mixed with Green and Blue"
Purple - Green
Purple - Blue

How do I create a relationship for both Color and Color_Mixed to point to
the only key field in the [Color] table?

I can only drag a "relationship" line from one table to another table. If
I drag another "relationship" line, Visio will give me an error.






--
There is no answer.
There has not been an answer.
There will not be an answer.
That IS the answer!
And I am screwed.
Deadline was due yesterday.

There is no point to life.
THAT IS THE POINT.
And we are screwed.
We will run out of oil soon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top