Tables that contain dot-walked fields from other tables that are mandatory can be submitted even if the mandatory field is not filled out.

Steps to Reproduce

  1. Go to

  2. Click New.

  3. Right-click on Requested for and select Configure Dictionary.

  4. Select the Mandatory check box and click Update.

    The Requested for field on the sc_req_item page now shows the red asterisk marking it as mandatory.

  5. Click Submit without entering anything into the Requested for field.

    The record is saved despite the mandatory field being blank.




This behavior is as designed. As noted in the product documentation topic Making a field mandatory, "a form can be saved with an empty mandatory field if that field is a reference field (derived from another table) and if the parent field is also blank. However, if the mandatory reference field shows a value from the parent field, then the form cannot be saved if this value is deleted."

As a workaround, create a similar client script as a workaround.

Table: <tablename> 
Type: onSubmit 

var mandField = g_form.getValue('<reftablename>.<fieldname>'); 
if (!mandField) { 
alert('There is an empty mandatory field!'); 
return false; 


Related Problem: PRB569134

Seen In

Aspen Patch 2
Aspen Patch 3
Fuji Patch 12
Fuji Patch 13 Hot Fix 1
Fuji Patch 4 Hot Fix 4
Geneva Patch 1 Hot Fix 7
Geneva Patch 3 Hot Fix 2
Geneva Patch 5
Helsinki Patch 5

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:37:51