Issue in cutom lokokup x++

(0) Share

Report

Posted on by Menna Allah Ahmed

163

I need to create lookup on custom tables deductionheader and deductionLine when I used joins between tables control doesn't open and service unavailable but when I used lookup on every single table it works fine

so what's wrong on these lookup on in tables relations ?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Menna, You don't need line# 66 to addLink as table relation exist so relations(true) is sufficient. Regarding your issue. Is the CustAccount unique field in header table?

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Meena,

You can create a view and use that view in lookup query to get better performance.

Thanks,

Girish S.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

As you are already making relations to true, then it is not required to add the link again in 66. Also I would suggest you to check the same query in SSMS. If that works then you need to debug your code.

Was this reply helpful? Yes No