Hi,
Considure me having two related tables,
Customer and Address
Address is a child to Customer.
Lets say I want to constrain all customers whos lastname is Anderson and lives in New York.
Code:
Object oCustomer_DD is a Customer_DataDictionary
Procedure OnConstrain
Constrain Customer.Lastname eq "Anderson"
Constrain Address.City eq "New York"
End_Procedure
End_Object
Object oAddress_DD is a Address_DataDictionary
Set Constrain_file to Customer.File_number
Set DDO_Server to oCustomer_DD
End_Object
The above code will trigger error
4154: Data_set constraint not for main file.
Is there a way to do such a constraint?