How to restrict related table records

(1) Share

Report

Posted on by Krishna4248

HELLO All,

KINDLY PLEASE REPLAY ME,

How to Restrict if the main record contains the related records, if main record contains one record, then related record also one record must exist, if main record exists two records, then related record also must contain two records.

I have added Workflow, If the above validation will work then only, we can be able to do submit otherwise It wants to show error ( Please Fill details like)

I wrote below code, it is validating only first record, not validating for second record.

//while select KTTypeLines
// where KTTypeLines.Dependent == KTDetails.Dependent
// && KTTypeLines.DependentRecId == KTDetails.DependentRecId
// && KTTypeLines.HeaderClaimRefID == KTDetails.HeaderClaimRefID
// && KTTypeLines.EmployeeNumber == KTDetails.EmployeeNumber

//{
// select KTDetails
// where KTDetails.HeaderClaimRefID == ltClaimHeader.ClaimReferenceID
// && KTDetails.EmployeeNumber == ltClaimHeader.EmployeeNumber;

// if(KTDetails.RecId == KTTypeLines.RecId )
// {

// data.submit(args);
// }
// else
// {
// throw error("KT details and KT lines are required");
// }

//}

All responses (3)

Answers (0)

a33ik 84,325 Most Valuable Professional on at

Like (0)

Report

RE: How to restrict related table records

Hello,

Please avoid creating duplicated threads.
Steve Zhao2 on at

Like (0)

Report

RE: How to restrict related table records

Hi Krishna4248,

It seems that you aren't using D365 Customer Service. Could you tell us which app are you using?
Krishna4248 32 on at

Like (1)

Report

How to restrict Reach Two grids contains minimum one record

HELLO All,

PLEASE REPLAY ME,

How to Restrict check if the main record contains the related records, if main record contains one record, then related record also one record must exist, if main record exists two records, then related record also must contain two records.

I have added Workflow, If the above validation will work then only, we can be able to do submit otherwise It wants to show error ( Please Fill details like)

I wrote code below code, it is validating only first record, not validating for second record.

//while select KTTypeLines
// where KTTypeLines.Dependent == KTDetails.Dependent
// && KTTypeLines.DependentRecId == KTDetails.DependentRecId
// && KTTypeLines.HeaderClaimRefID == KTDetails.HeaderClaimRefID
// && KTTypeLines.EmployeeNumber == KTDetails.EmployeeNumber

//{
// select KTDetails
// where KTDetails.HeaderClaimRefID == ltClaimHeader.ClaimReferenceID
// && KTDetails.EmployeeNumber == ltClaimHeader.EmployeeNumber;

// if(KTDetails.RecId == KTTypeLines.RecId )
// {

// data.submit(args);
// }
// else
// {
// throw error("KT details and KT lines are required");
// }

//}