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
But when I type the product name in search bar, in this case, I'll search for "One piece Keychain PVC"
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 ?
User | Count |
---|---|
15 | |
10 | |
7 | |
3 | |
2 |