Hi Folks, I need some help with something. It probably was raised before, but I couldn’t find it at the forum. Sorry.
I have a table which I’ll call “type”:
Fruit | Apple
Fruit | Lemon
Meat | Pork
Vegetable | Carrot
Vegetable | Tomato
(type here is referenced)
Now, I would like to have a table called “purchase”
Costumer | Type | Food
Eduardo | Fruits | Apple
Natalie | Vegetable | Carrot
The “wish” here is when I select “Fruits” as a reference, the next selection shows only “Apple” and “Lemon”.
Can I do that?
Thanks in advance! Sorry for asking for something already answered.