AnsweredAssumed Answered

How can I create a layout that displays categories, subcategories, and items?

Question asked by dbeval on Sep 24, 2017
Latest reply on Sep 25, 2017 by dbeval

Need to create a database with the following tables:

Categories

Subcategories

Items

A join table that connects subcategories to items.

 

A category can have one or more subcategories and a subcategory can have one or more items.

I created the tables, but my challenge is to create a layout with 3 lists. I would like to be able to

select a category, which should automatically list the corresponding subcategories. Then by selecting
a subcategory, the corresponding items should be displayed in the 3rd list.

 

Kind of similar to the folder view on the Mac.

 

list.png

 

Tried, but can't figure it out.

Outcomes