Hello,
I have a header and detail tables. I'm populating data in the detail table, but I want to create a check constraint on it based on a combination of values in the header and detail table.
Basically, header table has a bit column called Tag_Required, if the bit is checked then I need to make sure I supply Tag information in the detail table, if Tag_Required is not checked, then I don't need to pass anything into that column.
Can LLBL do this, I looked into setting this up right on SQL, but Check constraints are limited only to the specific table I'm working in, I can't link to a header table, so I think.
Thanks in advance.