Referencing Categories in another table

[Kat]

Good Evening,

I'm building an app for my mom, but am having issues with the groceries section. 

In the "Cart_Details_Inline" view I want the groceries to be sorted by category as they are in the "Groceries" view.  I've used a virtual column in the "Cart_Details" table to reference the Category column in the "Groceries" table.  Problem is, instead of categorizing by that column it is listing every category in the app.  How do I fix this?

Thank you!

[dbaum]

---

@Kat wrote:

I've used a virtual column in the "Cart_Details" table to reference the Category column in the "Groceries" table.

---

The App formula for that virtual column adds to every row a list of all the categories.

Instead, you presumably want only the category applicable to each row. Change the virtual column's App formula expression to a Dereference expressions - AppSheet Help. For example:

[RefColumn].[Category]