How do I get the customer number that selected by user through customer name

(0) Share

Report

Posted on by richard man

Hi, all

When user select one row in the list, Customer name will be display on it ,and I need use the Customer Number as a condition to select data from DB, Now the problem is I can not get the number in the contract or data provider. anyone can help me ?

Best regards.

All responses (4)

Answers (0)

GirishS 27,825 Moderator on at

Like (0)

Report

RE: How do I get the customer number that selected by user through customer name

I am still not able to understand your issue?

Filters works only for the fields that are first added via "addLookupUpField" method.

If you add customer name you can search by name and if you add customer number you can search by number - Both wont work at the same time.

Is this the issue you are asking?

Thanks,

Girish S.
richard man 20 on at

Like (0)

Report

RE: How do I get the customer number that selected by user through customer name

The problem is SysTableLookup method can return only one item at once.
richard man 20 on at

Like (0)

Report

RE: How do I get the customer number that selected by user through customer name

Hi, GirishS

First of all, thank you for your reply, my request is that the user can see the name and number at the same time, when the user enters the customer name in the search box, search by name, when the user selects one, the page displays the customer name, and at the same time uses the customer number in the data selected by the customer as the search condition.
GirishS 27,825 Moderator on at

Like (0)

Report

RE: How do I get the customer number that selected by user through customer name

Hi richard man,

You need to get the customer number from customer name?

You can get customer number from the customer name but the customer name wont be unique sometimes.

So it will be better to add the customer number in the report instead of customer name.

Thanks,

Girish S.