Dependent Dropdown from multiple sheets

AppSheet AppSheet Q&A
, ,
1

My worksheet has following two tables

Table 1 : Category

  • category_id

  • main_category

  • sub_category

Table 2 : Vendors

  • vendor_id

  • sub_category

  • venodor_name

Table 1 : Category Sample data as follows

  1. 1,ENTERTAINMENT,OTT

  2. 2,SHOPPING,SHOPPING_APPS

Table 2 : Vendor List sample data as follows

  1. 1,OTT,Netflix
  2. 2,OTT,Hotstar
  3. 3,OTT,Sony Live
  4. 4,OTT,SHOPPING_APPS, Amazon
  5. 5,OTT,SHOPPING_APPS, Walmart

How to make a depended dropdown using two sheets / two tables in a single view.
ie when user select category dropdown, it shows dependent sub category when user select a sub category it further shows vendor dependent dropdown.