Hi all.
I create a new table (table A).
Index of table A is combined field (A.cmba contained A.xxxx, A.yyyy)
- field A.xxxx is string(20) [mandatory]
- field A.yyyy is long [not mandatory, because 0 must be allowed]

I have table B. Table B contain fields xxxx, yyyy. Pair B.xxxx and B.yyyy included in combined field B.cmbd

I need referential integrity for both tables.
So: B.cmbd refered to table A (mandatory unless empty, Delete mode: loockup restricked, update mode: no check)

Problem:
One or more records present in table B(for my index key). On delete action in table A checks not occurs, Record removed. (but message "... may take a long time..." present)

Why Check DBMS not work for combined field? For usual field all works good. DD created, in /baan/bse/dict/ all ok (REFC records)

Any idea?

Several ideas - first on table A do not use a combined field as the primary index. Just use the xxxx and yyyy fields. See if that works. Next after changing the index try making a.yyyy as mandatory - wonder if it has to do with an empty field and/or a null field. This is the order I would try them in.