Are you trying to delete a column which is part of a
primary key|foreign key relationship?
If do you will have to drop the FK constraint to do this.
[quoted text, click to view] >-----Original Message-----
>I have these two tables can link with out problem, it
does
>not work on SQL.
>
>'Store List' table saved successfully
>'EQUIPS' table
>- Unable to create relationship 'FK_EQUIPS_Store List'.
>ADO error: ALTER TABLE statement conflicted with COLUMN
>FOREIGN KEY constraint 'FK_EQUIPS_Store List'. The
>conflict occurred in database 'RMA', table 'Store List',
>column 'Store Number'.
>.