[thelist] SQL server MS DB cannot form relationships help?
A Maynes
andrew at milords.com
Mon Jun 11 11:14:23 CDT 2007
Could someone point me to a good resourse for creating relationships on
tables that MS Access is using please?
I get this in enterprise mamager
'Products' table saved successfully
'Suppliers' table
- Unable to create relationship 'FK_Suppliers_Products'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE
statement conflicted with COLUMN FOREIGN KEY constraint
'FK_Suppliers_Products'. The conflict occurred in database 'sevendo',
table 'Products', column 'ProductID'.
More information about the thelist
mailing list