customer name in lookup with multiselect

(0) Share

Report

Posted on by Gautam

3,945

hi all,
I want to give the customer name in lookup with multiselect , but the problem is that custname field is not present in the CustTable.

I know lookup with multiselect when field is present in the table , but here field is not present.

So please suggest how to do that
Thanks
Gautam

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

Suggested answer

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Simply join CustTable with DirpartyTable.

Names are no more present in Cust or vendTable. These are saved with party

tech.alirazazaidi.com/custom-lookup-field-with-no-exist-join-records-dynamics-ax-2012

Was this reply helpful? Yes No
Suggested answer

Jonathan Halland 11,310 on at

Like (0)

Report

Hi Gautam.

I'm not sure if I understand your quesion entirely, but on the CustTable table in the AOT you can drag the "name" method into the AutoLookup field group. This may resolve your issue depending on the context

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

Hi Gautam,

The names are stored in DirPartyTable.name field. The relation between CustTable and DirPartyTable is as follows:

CustTable.Party = DirPartyTable.RecId.

Use the above relation to retrieve the customer name. You can also check the name() method on CustTable method to get more details around this.

Please verify and let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

hi baber i need this in lookup actually .

How i will write this relation in lookup

Was this reply helpful? Yes No
Jonathan Halland 11,310 on at

Like (0)

Report

Hi Gautam. Can you not use the default functionality as described in my post above?

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

Sohaib you are right and the link which you have given is for lookup only , i need lookup with multiselect , that is the problem

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Gautam,

To give customer a lookup name, first you have to create new register in GlobalAddressBookListPage form. Then click customer button on action pane. This field is not in customer table, but it is in (DirPartyTable).NameAlias.

I hope help you.

Best regards,

Richardson

Was this reply helpful? Yes No
Suggested answer

syed baber 11,633 on at

Like (0)

Report

Hi Gautam,

The SysLookupMultiSelect class uses a query object to show the values. You need to create a query using Query class to include CustTable and DirPartyTable. The post which Sohaib mentioned, has the code to create a query including these two tables. Have a look at that and let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

how you are doing multiselect, in any class/dialog or on any form?

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

in form

Was this reply helpful? Yes No