Originally Posted by vroberts
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_InterfacePartners_Components". The conflict occurred in database "Meds", table "dbo.Components", column 'ComponentId'.
The statement has been terminated.

You are going to need to get AC support involved to fix this.

FK conflicts on inserts won't be resolved by themselves.

It will have to get passed up the food-chain in support to someone who is familiar with the DB structures, and can script/run the corrective commands.


Indy
"Boss"

Indy's Blog

www.BestForYourPractice.com
Our Name is Our Creed