Hi, All

I am trying to create a foreign key reference into a table through SPT from VFP. This is the code that I setup, but SQL Server sends back an error.

  lcInsertStr = "ALTER TABLE " + lcTableName + " ADD CONSTRAINT STUDNT_ID_ FOREIGN KEY REFERENCES STUDNT (STUDNT_ID_)"

the error is:

1526 Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Number of referencing columns in foreign key differs from number of referenced columns, table 'STUTRN'.

TIA
Beth