Skip to Content
0
Former Member
Apr 19, 2005 at 08:45 PM

Validate columns in UDT against existing tables

99 Views

I want to create a User Defined Table that has a column that is validated against an existing SBO table, such as OCRD. I can table validate against another UDT but AFAIK I can't against an existing table.

If I'm wrong (I hope so), can it be done from the GUI of SBO or can you do it in the SDK? If so, how? If not, how horrible (unwise) would it be to add a foreign key constraint directly from SQL?

TIA.