Segregate Data from subform of Form-A and fill data in another subform of Form-B.

Segregate Data from subform of Form-A and fill data in another subform of Form-B.

Hi, this is my Subform "Assign Items to Existing Supplier" of Form-A


Now each supplier should see their details only, so we have Supplier Form (Form-B) which has subform called Quotation--

For Supplier A subform should look like

Deliverable    Quantity   Subtotal
Camera                1  
Carpet                   1


For Supplier B( Rishabh 969 here ) subform should look like

Deliverable    Quantity   Subtotal
Carpet                  1  
Stylist                   1

I tried but cant get it correct but I know that my end collection variable if looks like this I can make it work --

  1. col = ["Vendor" : { "Carpet" : 1 , "Camera" : 1 } , "Rishabh 969" : {"Carpet" : 1 , "Stylist" :1 }];
But the inner list is one that I am facing difficulty with,or if there is another method please do let me know.
Feel free to let me know if more explanation is needed.