Conditional Value Lists
I just don't get this. I have watched video after video but don't understand. Here is my problem. With a budget, I have categories and subcategories. When I choose a category, I would like only the subcategories that belong with that category to show. What I am not sure about is which table do I make another occurrence. Is the duplicate table the subcategory table and what do I link it to in the category table?
I am attaching a layout where I try to link the subcategory to the category but it doesn't let me do it.
Help is very appreciated.