Re: Constraints, anyone?

Can you give some more detail? Like are you saying that

FOOREF
PRITBLNUM PRITBLENT SECTBLNUM SECTBLENT
ADT M
ADT Z
XYZ A
XYZ M

FOODTL
COLUMNA COLUMNB PRITBLENT
000001 001 M
000001 002 Z
000002 003 M

and the logic is that, since this is the FOODTL table then PRITBLENT here
implies PRITBLNUM of ADT and that there should be an ADT record in FOOREF
with a value of M before M can be assigned to PRITBLENT of FOODTL? No, a
constraint will not do that. FOODTL would have to have both PRITBLNUM and
PRITBLENT. Or you should normalize FOOREF into separate tables based on
PRITBLNUM. You could also put a trigger on FOODTL that enforces your
existing table setup.


Rob Berendt