can anyone tell me how that “Search Name” thing is working? i have a general ledger account with “No.” = ‘2230’ and “Seach Name” = ‘OANAUBM’. now if i insert this account into an order by entering ‘OANAUBM’ i get the right account. now i was wondering: how does navision do that? In the debugger, in the Trigger “No. - OnValidate” on the very first line i already have ‘2230’ in the field SalesLine.“No.” … Where does navision convert the search name into to the right no.? i dont get it.
Have a look at the property “AltSearchField” on the primary key field…
In the properties of a field there is a property called ‘AltSearchField’. This is responsible for your stunning result [:)] So in table ‘G/L Account’ the AltSearchField of No. is Searchname …
well … and if i set ValidateTableRelation to false on the salesline, that field does not work anymore … oh weak!
quote:
Originally posted by ahed4
well … and if i set ValidateTableRelation to false on the salesline, that field does not work anymore … oh weak!
No, of course not; and why would you want to do that?