How to create relation between two grids on customized form.

(0) Share

Report

Posted on by Munib Ahmed

how to create relation between two grids on the basis of recid I wanted quotationlines lines against item from serviceOrderLines i wanted to see quotationLInes Against selected Items from ServiceOrderLines grid.

I created Relation between ServiceRequestLinesTable and ServiceRequestQuotationLines their screenshot is below:

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Munib,

If you set the join source property on the form, it will work properly. Make ServiceRequesetLineTable as a Parent DataSource and on the property of the ServiceRequesetQuotationLines DataSource set the Join source property to ServiceRequesetLineTable.

Grid will filter based on that.

Thanks.

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Munib, Check this article

community.dynamics.com/.../868133

Was this reply helpful? Yes No
Munib Ahmed 31 on at

Like (0)

Report
Copy link

Link copied!

Hi Girish,

Thanks for reply

I already did that but when i created new record in serviceOrderLines Grid means when i added new item and then added its quotationLInes in service order quotation Lines grid and save that and then when i open the record again the ServiceQuotationLines against items are vanished but they are saving in database.

Actually I am created ServiceRequest Customized form in which first grid " ServiceRequestLines" are actually arrival items and second Grid its quotations against arrival item.

i am also attaching the screenshot of form so you can understand below:

Was this reply helpful? Yes No
Verified answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Do you have added any other range on the form. Check whether you have added any other range on the form.

If the record is not shown in the form, then the relation field in child table is not filling in. After adding record check whether that field values is filled in.

Thanks,

Girish S.

Was this reply helpful? Yes No
Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

In addition to above suggestion, you can also check what's the query generated for the form. Add info(this.query().toString()) in executeQuery method. Based on the query, you can validate if there is valid data or you need to make some changes in your form.

Was this reply helpful? Yes No
Munib Ahmed 31 on at

Like (0)

Report
Copy link

Link copied!

thanks it solves my problem

Was this reply helpful? Yes No