Skip to Content
Former Member
Sep 23, 2007 at 09:37 AM

Foreign Key issue


I have a issue with this foreign key.I created two tables like"


mandt PK

subid PK



mandt PK

studid PK

stud name

stud add

subid FK

First I created zsubmaster,then zstudmaster set subid to FK with zsubmaster.I entered records in zsubmaster 1 english,2 mathematics, 3 social.

I started entering records in zstudmaster and 'check table' push button is visible.When the cursor is in subid,dropdown appeared.When I click it those 1,2 and 3 records are seen.But if i enter 4 in sub id and save it,record is saved.I dont understand how,to my knowledge 4 should exist in zsubmaster or else it should not be saved.Can you please suggest me,how it happened?

Thanks in advance.