Inventory Control - drill down

Inventory Control - drill down

Hello Zoho team,

Our organization has been using Zoho creatoe for tracking inventory online. We would like to have the capability of linking spreadsheets for e.g. "List 1" has fields of -

--Name of product
--Current Inventory
--Minimum inventory to hold
--Individual cost
--Total Cost

I would like to create another spreadsheet "List 2" which has
--Name of product
--List of clients the product was shipped to
--Number of units shipped to individual clients
--Date of shipping
--Payment received (Y/N)

List 1: List2 would be joined by "Name of the product" and would be a [1:many] relationship. Having the capability of drilling down from Name of the product (unique) to get a list of all clients listed who have been shipped the product would be great! For e.g. of I drill down on product X, the new view could look like -

Product X | Client Smith| 20 units| 20th June| Y
Product X | Client Bill | 25 units| 19th June| Y
Product X | Client Peter | 24 units| 20th July | Y

The same would be for product Y, Product Z etc.

This would help us save a lot of time in tracking products and payments.

I'd appreciate a good solution!

Cheers!

Kuldip
kuldipkamat@gmail.com