How to search labels in dropdown

Hi, 
Your help will be really appreciated

So I have 3 tables related to this concern,
Product table = Contains ProductID(Key),ProductName(label) and more details
Stock Table = References ProductID , contains quantity, cost, and srp
OrderDetails= references Stockid , Soldprice and quantity

Now, Here is the dropdown from orderdetails view
Screenshot 2023-06-30 at 9.39.34 PM.png

But when I type the product name in search bar, in this case, I'll search for "One piece Keychain PVC"
Screenshot 2023-06-30 at 9.39.51 PM.png

I believe the search bar uses the productID key value that's referenced in the Stock table instead of the label.
This will lead to a problem when my employee tries to search for an item.

Any idea how to solve this ? 

0 3 127
3 REPLIES 3
Top Labels in this Space