
Hello Everyone,
I am trying to imitate the behavior of the customer dropdown (or description dropdown) in sales document.
With that I mean, a dropdown field where I can select a customer, it displays it's name, but it is it's no. that is actually saved in the database.
Can you guys please help me do that?
When I do a TableRelation = Customer, it only allows me to use No., as Name is not a primary key. And since customer is a system table, I cannot add name as a primary key.
Regards