AnsweredAssumed Answered

Help!!! Need to create conditional pop-up or drop-down lists

Question asked by leonhart1981_1 on Nov 13, 2017
Latest reply on Nov 13, 2017 by philmodjunk

I want to create a product database with three conditional value lists for my Product's category, sub-category, and type. However, it's been awhile since I created the database using FileMaker Pro, so I am kinda lost how to start it and wondering if anyone could give me a guidance.

 

I have five main categories in my products: Speaker, Amplifier, Signal Processor, Sound Controller, and Headphone

 

Then, below are the sub-categories for each main categories following with their types:

 

Category  > Sub-Category >  Type

Speaker > Car Audio (CA) > Coaxial (CX)

                                          > Woofer (WF)

                                          > Mid (MD)

                                          > Tweeter (TW)

                                          > Enclosure (EN)

 

Speaker  > Home Audio (HM) > In-Wall (IW)

                                                > In-Ceiling (IC)

                                                > Sound Bar (SB)

                                                > Garden (GN)

 

Speaker > Marine Audio (MR) > Coaxial (CX)

                                                > Woofer (CX)

                                                > Waketower (WT)

 

Speaker > Power Sport (PS) > ATV (AT)

                                              > UTV (UT)

                                              > Motorcycle (MT)

 

Amplifier > Multiple Audio (CA) > NIL

               > Multiple Audio (MR) > NIL

               > Multiple Audio (PS) > NIL

 

Signal Processor > Multiple Audio (EQ) > NIL

                            > Multiple Audio (DSP) > NIL

                            > Multiple Audio (EP) > NIL

 

Sound Controller > Multiple Audio (MU) > NIL

 

Headphone > Personal Entertainment (PE) > NIL

 

Here is what I wanna do, I want to create a conditional pop-up list that when choose "Speaker", the sub-category pop-up list will only show "Car Audio", "Home Audio", "Marine Audio", and "Power Sport". Then, when I click "Car Audio", another pop-up list or draw-down menu will show "Coaxial", "Woofer", "Enclosure"...etc

 

But if the Category is "Amplifier", the sub-category will be "Multiple Audio (CA)", "Multiple Audio (MR)", and "Multiple Audio (PS), but the Type will only show "NIL".

 

In this case, where should I start it? I have totally forgot how to do it Please help!!!!!!

Outcomes