Need to create a database with the following tables:
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.
Tried, but can't figure it out.