Foregin Key in SQL

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

  • : 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..
  • : : 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.

Howdy, Stranger!

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

Categories

In this Discussion