my master table is COMMON_SECTION in schema HRMS with columns
Section_id number(2); Primary key
my child table is FABRIC_ISSUE in schema SMS with columns
Fabric_id number(7); Primary Key
FROM_SECTION number(2); "wana make it FK of section_id"
now i wanna make FROM_SECTION foreign key of Section_id which is a primary key in some other schema with a different name
it issues error ORA-02270: no matching unique or primary key for this column-list
i tried making synonyms of common_section into SMS schema where my child table is. same i tried making view but to no avail.
kinldy sooner gimme some solution