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的原创文章，请关注公众号"汪子熙":