Hi there, quick question here:
I have several sheets in my excel workbook, all of them are on line with Share Point lists "connected"
All of the list have a common field i.e OrderID
I have list as:
Orders
ProductsOnOrder
Customers
Vendors
ShippingAddress
My main list is Orders:
OrderID | Customer | OrderDate |
1000 ABC Jun 21
1001 DEF Jun 22
1002 SED Jun 22
ProductsOnOrder
ID | OrderID | Product
1 1000 A
2 1000 B
3 1000 C
4 1000 D
5 1001 A
6 1002 A
7 1002 B
I have in excel a blank sheet with a legacy control dropdown that pull the Orders from my main list "Orders" and in that sheet I have something like a report form with several VLookup that check the OrderID value and retrieve the required field.
So everything is fine and works as expected. My problem is when I select an OrderID I would like to see the products for that order. But in many cases my order has more than one item. I don't know how to show those products in something like a subform, table etc. If I do a Vlookup I am able to retrieve the first item that match with my OrderID.
Any idea?
thanks in advance for any help.
Regards
Bookmarks