update of foreign key

[cards4]

Hello,
Yesterday, I posted a question concerning UPDATE. The solution presented to me was helpful, however, a new error has occurred. This is my query:

update table set emp_id='???', empno='???', soc_sec_no='???'
where (soc_sec_no='???' and emp_id='???' and empno='???')

When I run this query, I get the following error:
UPDATE statement conflicted with TABLE REFERENCE constraint 'R_195'. The conflict occurred in database '???', table 'table1'.
The statement has been terminated.

I'm not entirely sure what this error message is saying. Please help. Thanks.

The ??? represents data and is not in my actual query.

 

[bborissov]

That mean you have a relation between table you want to update and some other table and you want to set the values for one (or more) field(s) and that value does not exists in parent table. Check R_195 constrain to see in what field you didn't put the right value.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP