Selecting data from table based on selected values in form

[Harsh_Rathore]

Hi All,

I am trying to create an Order Portal app and struck on a situation. I have a table ‘Table1’ which has my list of orders from Customers populated using form (columns - Customer Name, Order Generated Date, Products Ordered, Qty, Order Delivered Date). Now I want another view where my Distributor can view open orders (where Order Delivered Date is null) and select order which he can deliver (based on key Customer Name, Order Generated Date and Product Ordered). Using detail view on Table1, I can update the Order Delivered Date manually, but that is difficult due to large table size. One approach I could think of is where in separate table Table2: Distributor can put Customer Name, Order Generated Date using forms and it will pull Product Ordered and Distributor can assign Delivery Date to it. Is there any way to achive this functionality