The DELETE statement conflicted with the REFERENCE constraint
I need to delete a Visit Transaction and getting this message -
Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the REFERENCE constraint "FK_Transactions_VisitTransactionsId". The conflict occurred in database "pc", table "dbo.Transactions", column 'VisitTransactionsId'.
The statement has been terminated.
DELETE FROM visittransactions where VisitTransactionsId = '592167'