How to make invoice portal easy to enter items?

Discussion created by Angelus81 on Aug 21, 2016
Latest reply on Aug 27, 2016 by philmodjunk

Below image is what I create for my "Order" table.


The Item field is related to my inventory table. Currently, I use pop-up menu for the item field and its value is from "Inventory" table's primary ID but display using second field. However, in this case, every time when I need to create an order invoice I need to select the item from the pop-up menu list one by one. Is there a convenient way that I could key-in the item name directly from field but it will still pull related information, such as its price.



Screenshot 2016-08-21 20.29.36.png