That there are some records in child table that does not exists in the parent,
so either got to add those records to parent table or drop orphan records
from child right?what is the query for obtaining what parent table
is the foreign key referencing to and to obtain the orphan records ,i'll
apperciate that.

Thanks PAVB for your help

Thanks