Foregin Key in SQL - Programmers Heaven

Howdy, Stranger!

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

Categories

Foregin Key in SQL

DimDimDimDim Posts: 7Member
Can someone tell me how to write a Foreign key statement in SQL for MS Access between a int in one table and a Counter that is the PRIMARY KEY for the other table

Comments

  • HappelHappel Posts: 42Member
    : Can someone tell me how to write a Foreign key statement in SQL for MS Access between a int in one table and a Counter that is the PRIMARY KEY for the other table
    :

    Don't think that is possible, COUNTER is of type LONG.
    Anyway, I you get it working then your
    DBMS isn't the one I would use ;-)

    You'll always end up with problems..
  • DimDimDimDim Posts: 7Member
    : : Can someone tell me how to write a Foreign key statement in SQL for MS Access between a int in one table and a Counter that is the PRIMARY KEY for the other table
    : :
    :
    : Don't think that is possible, COUNTER is of type LONG.
    : Anyway, I you get it working then your
    : DBMS isn't the one I would use ;-)
    :
    : You'll always end up with problems..
    :

    I solved the problem my self by first Creating the Table and the altering it to add the Foreign Key

Sign In or Register to comment.