Customer."Search Name"

icobani

How work "Sales Header"."Sell-to Customer No." and Customer."Search Name" relation. I m not undersand. please help me. I want same relation another custom tables.

thanks.[/b]

Waldo

Imho, they have no relation at all .. can you give more info?

icobani

Waldo wrote:

Imho, they have no relation at all .. can you give more info?

Ok I m opening Orders form and press F3 and Enter. It find customer when I m entering a search name on the "sell-to customer no". I look Sell-to Customer No. On Validate triger but not find a code. I m not understand.

David_Singleton

icobani wrote:

How work "Sales Header"."Sell-to Customer No." and Customer."Search Name" relation. I m not undersand. please help me. I want same relation another custom tables.

thanks.[/b]

Actually they are linked, but at first glance it is not so obvious.

If you look at the customer table:18 then look at properties for "No.", field:1.
find the property AltSearchField and you will see that this points to Search name.

Navision allows you to add an alternate field for searching in a linked table.

this mean s that any field in another table (e.g. "Sales Header"."Sell-to Customer No.") that linkes to table 18, field 1, will also link to the Search name.

This link ONLY works for manual keyboard entry. Basically if it does not find a record with the primary key, it then searches the AltSearchField instead. Of course there is still the limit that you can only enter 20 characters, but it is really useful if you want to enter the customer name instead of the umber.

icobani

David Singleton wrote:

icobani wrote:

How work "Sales Header"."Sell-to Customer No." and Customer."Search Name" relation. I m not undersand. please help me. I want same relation another custom tables.

thanks.[/b]

Actually they are linked, but at first glance it is not so obvious.

If you look at the customer table:18 then look at properties for "No.", field:1.
find the property AltSearchField and you will see that this points to Search name.

Navision allows you to add an alternate field for searching in a linked table.

this mean s that any field in another table (e.g. "Sales Header"."Sell-to Customer No.") that linkes to table 18, field 1, will also link to the Search name.

This link ONLY works for manual keyboard entry. Basically if it does not find a record with the primary key, it then searches the AltSearchField instead. Of course there is still the limit that you can only enter 20 characters, but it is really useful if you want to enter the customer name instead of the umber.

Thanks David,

But I have a problem My primary key is include 2 field. how can I solve this problem.

David_Singleton

icobani wrote:

Thanks David,

But I have a problem My primary key is include 2 field. how can I solve this problem.

OK, so I guess that the customer thing is not a problem, but just that that is what you were tryingto replicate. Well you are for sure doing it the right way, i.e. copying standard navision functionality. But...

In this case I don't think that will work. I assume you are drilling down on the second part of the primary key, but then I am not sure how you would do it. For sure it might be possible, but I have never tried. Of course you could do it in code, but that would be very messy.

Can you describe exactly what you are trying to achieve.