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