I have 4 Sharepoint list
Vendors
Products
Orders
Order Details
When I create new Order, i want to add products to that order, is there any control to add a search field, and lookup products, and when i select one product, add the product to the table control?
I need to add quantity and the product to the product table control
You can use List or Library control to allow users to add products to the order with quantity. For this, you will need to create one more list ProductTable with these columns:
Product - lookup column to the Products list
Quantity - number column
Order - lookup to the Orders list (for connecting ProductTable and Orders lists)
Please find the instructions on how to set up List or Library control here: