Relating sheets many to many
Hi there. I am trying to design a set of sheets in Smartsheet to allow two different types of projects to be related to one another. I have species projects in one sheet and site projects in another sheet. I want to relate these two sheets such that one species can be related to multiple sites and one site can be related to multiple species. I know this is a different use case than many, but I think it's similar to someone wanting to have a table of orders related to a table of products, where an order could have one or 100+ products, and one product may exist in one or 100+ orders. One goal with this would be to click on one order and display all the products (and all product info stored in that table) or to summarize that, and also conversely, click on a product and display all the orders and allow summarizing.
Is this possible in SmartSheet?