[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