Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Mysql Foreign

jb160rrjjjb160rrjj Member Posts: 2
[b][red]This message was edited by jb160rrjj at 2003-7-30 7:20:10[/red][/b][hr]
[b][red]This message was edited by jb160rrjj at 2003-7-30 7:19:52[/red][/b][hr]
If I create a table that has multiple foreign keys that reference another table in which the primary key is referenced by all three. So if my table looks like this.


Table 1
ID_NUmber Primary Key
Bill_ID FK
Tech_ID FK
Zone_ID FK


Table 2
Contact_ID PK
Name



I want all of those fk's in table 1
to reference the Contact_ID in table 2
because each of those foreign keys in table 1
could have the same value contact_ID

thanks for any help


Comments

  • jb160rrjjjb160rrjj Member Posts: 2
    : [b][red]This message was edited by jb160rrjj at 2003-7-30 7:20:10[/red][/b][hr]
    : [b][red]This message was edited by jb160rrjj at 2003-7-30 7:19:52[/red][/b][hr]
    : If I create a table that has multiple foreign keys that reference another table in which the primary key is referenced by all three. So if my table looks like this.
    :
    :
    : Table 1
    : ID_NUmber Primary Key
    : Bill_ID FK
    : Tech_ID FK
    : Zone_ID FK
    :
    :
    : Table 2
    : Contact_ID PK
    : Name
    :
    :
    :
    : I want all of those fk's in table 1
    : to reference the Contact_ID in table 2
    : because each of those foreign keys in table 1
    : could have the same value contact_ID
    :
    : thanks for any help
    :
    :
    :

Sign In or Register to comment.