Finding all related rows by selecting one parameter

[dfk1988]

I'm working on creating an inventory appsheet. Every row is for one sku in one bin location. Therefore, there can be multiple entries for one sku in different locations. When I'm viewing one row in appsheet, is it possible to set it up so that I can "click" the sku and then be taken to a screen that shows me every entry with the same sku?

[Joseph_Seddik]

Welcome to the community!

Yes, this is what relational databases do. Please read:

Data: The Essentials | AppSheet Help Center 

References Between Tables | AppSheet Help Center 

[dfk1988]

Thanks, this is very helpful. Is it possible to reference a column with itself? I see the linked tables but I'd like to be able to "click" a sku when viewing one row and see all other rows with the exact same sku in that table.

[dfk1988]

Also - I was able to link two tables with one column as a reference to the other table, however the automatically created "Related Comparisons" column is yielding 0 comparisons in every single row. Is there any info to troubleshoot this?

[Joseph_Seddik · Accepted solution]

When you have an SKUs table referenced by all other tables containing an SKU column, you’ll be able to click an SKU value anywhere in your app and view all occurrences of this SKU. You can also create filtered views as desired. 

As for your other question, please read this:

https://help.appsheet.com/en/articles/1023086-what-is-a-key

[dfk1988]

that did the trick. Thanks for your help!