I have a Contact layout (table Contacts) which also displays a portal (table ContactTypes) allowing the user to enter many contact types for a Contact. I need to make sure that at least one record is always entered by the user in the portal for each contact that is created or modified. Where should I put this validation on the Contact layout, and what would be the commands ?

Similarly, I would need to create a script that would scan all Contact records, and create a record in the portal (ContactTypes) for this contact if none was found. The new record created would be assigned a static contact type value (ex: "General").

Thanks

You can check if there is a record in portal with IsValid () function and to check if there is only one or more records you can use Count () function.

HTH

You could also use the IsEmpty(RelatedTable::RelatedField) Function.