In SharePoint Online, Out-of-the-Box, I have not found a way to solve a one-to-many relationship. I am a junior member of a Dev team and I would like to understand how I could do the following:
List-1 is product inventory list (primay key = product #) contains “Product #” field and at laest 10 fields for each product.
List-2 has “Product #” , Location #, multiple buildings & rooms where these products are storedÂ
Example of data in List-2
Product #   Location #    Building Name    Room Name or #
Product-001Â Â Â L-001Â Â Â Â Â Â Â Building-AÂ Â Â Â Â Â Janitor Closet
Product-001Â Â Â L-002Â Â Â Â Â Â Â Building-AÂ Â Â Â Â Â Operations Sink Cabinet
Product-001Â Â Â L-003Â Â Â Â Â Â Â Building-BÂ Â Â Â Â Â Janitor Closet
Product-001Â Â Â L-004Â Â Â Â Â Â Â Building-BÂ Â Â Â Â Â Maintenance Rm#10
Product-002Â Â Â L-001Â Â Â Â Â Â Â Building-AÂ Â Â Â Â Â Maintenance Rm#2
Product-002Â Â Â L-002Â Â Â Â Â Â Â Building-AÂ Â Â Â Â Â Emergency Generator
Product-002Â Â Â L-003Â Â Â Â Â Â Â Building-BÂ Â Â Â Â Â Lab-789
Product-002Â Â Â L-004Â Â Â Â Â Â Â Building-CÂ Â Â Â Â Â Lab-456
User requested search “by Building” results:
==================
Search results for Building-A
==================
(First Column comes from List-2)Â Â Â Â Â Â Â Â Â Â Â (All other columns comes from List-1)
Room Name or #Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Product #Â Â Â other List-1 columns…
Janitor Closet; Operations Sink Cabinet        Product-001   Â
Maintenance Rm#2; Emergency Generator     Product-002
We give your substance the most obvious opportunity it can need to rank for pertinent catchphrases and expressions. There are more eCommerce alternatives accessible today than at any time in recent memory. It’s additionally simpler and more moderate than any other time in recent memory to sell on the web. Get in touch with us to talk about your extend and figure out which eCommerce arrangement is generally fitting for your long and transient objectives. For a long time, we’ve helped our clients increment profitability with custom web applications constructed only for them.
In case we’re going to do this, we’re going to do it right. Accomplices the entire way. Since the enchantment occurs in that space between the development encounters that construct brand dedication and the client encounters that reward them. Website Development Company In Delhi help the company in each vertical go-to-showcase and develop by working together, executing, and continually improving a custom methodology.
