Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Foreign Key issue

I previously posted the same but didnt get answer.The problem is that I created a table zforeign with fid and fname as fields.I mapped fid as foreign key with id field of check table zgtable.When I enter data in zforeign,for fid field list shows with corresponding values from check table.I select any one value and save it.Other than selecting,if i enter a value 123(which is not in check table),this record also gets saved.I think it should prevent me saving since 123 record is not found in check table.Can anyone tell me why its happening like that?Iam using 4.7 and check required check box is clicked while creating foreign key.

Not what you were looking for? View more on this topic or Ask a question