I have a product table with a list of related vendors.
I want to make vendor cost field in the related table a required value, but when I set field validation to 'not empty' and try to leave the layout, it doesn't trigger the validation on the related record.
How do I force a user to enter a value into a field in a related record?
Edit: I just added a script trigger on field exit to check if the field is empty. This works since after adding the vendor, the user in the cost field. If I had more than 1 required field, this method wouldn't work though.