In templates like sales orders, the field that links and loads the customer is the CustomerID. Since we wont remember customer numbers, we have to click and open the list then search by name and select it from the list. If we make the CustomerID something that resembles the name, we can just type and select the customer without going to the pop-up list. In the long run, will this make the database slower?
Another alternative is letting the CustomerID be an autogenerated number, but we use the CustmerName as the Link and Load pivot to load his other information. Then we can just type the name avoiding the pop-up list. Again will this practice slow the database?