User is deleted

[Mahesho11]

In a table records the user is deleted 

ex- security table 

application name - reference - sys_group

owner - reference - sys_user -mandatory-  here after record is submitted.

the user is deleted in table for some of application name. So, in that place empty field owner sys-id is coming so I unable to show error message on submit client script if owner is empty because of sys id the form is submitting. 

Any one explain please 

[Maik Skoddow]

Hi @Mahesho11 

sorry, I have no idea what you are talking about. Better information and some screenshots would be really helpful to understand you.

Maik

[Mahesho11]

[Mahesho11]

I have shared u the screenshot please check. 

Here the problem is in security group table - I have filled security group name with the help sys_user_group, and owner from sys_user table. I have given some value to both. for example after the form is submitted I have deleted the user in that form. In catalog item if i selected the security name the owner should auto populate. So, if I use same security name then the owner is showing empty but I unable to show error message the form is submitting automatically. So, I got to know later the sys_id is present but the user got deleted with the help of alert and getValue i found it. 

This scenario is I am facing in my DEV environment in my project. Can u please guide me how to remove that sy_id if value is empty. 

Please help me and explain in detail.

[Mahesho11]

Please see the information I have provided to you and help me.