Created by Jerry Wang on Sep 29, 2016
Missing entry in check table will NOT hinder CRUD of host table. This is verified by example below:
I have a host table whose field PROD_ID is linked by check table ZCHECK_REF:
content of check table:
content of host table:
As a result, I could see both in value help:
Now I would like to insert a new entry with key = Z3. This key does not exist in check table ZCHECK_REF. Will this creation be successfully done?
Yes.
The only defect is, when you try to create a new entry in host table, by clicking F4 for PROD_ID, you can only see Z1 and Z2, still Z3 is not in check table.
Read & Update:
Test ok.
Delete:
Test also ok.
要获取更多Jerry的原创文章，请关注公众号"汪子熙":