'Foregin Key in SQL' Thread RSS Feed

Foregin Key in SQL

Tue, 20 May 2003 05:12:30 -0700

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

Re: Foregin Key in SQL

Tue, 20 May 2003 23:57:35 -0700

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

Re: Foregin Key in SQL

Wed, 21 May 2003 23:11:06 -0700

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