Dropdown lists that effect each other

[WCP]

Hi. I'm an ultra-beginner with FileMaker and I know only what I've learned by occasionally playing around with it for work. Now I'm expected to do something with it that is beyound my ability, but nobody else can do it either.... I would appreciate any help with this you can offer.

We have a database full of products, and each products will be classified with a Category and a SubCategory. For example, a women's jacket would have Clothing as its category and Jackets as its subcategory. Each category has a list of subcategories that subdivide it.

What I have on each products page are a dropdown box for Category and to the right of it, one for SubCategory, both are dropdowns. The way we have it now, the entire list of SubCategories for each Category is available on the SubCategory list. Because there are 80-something SubCategories, this makes a long list and is inconvenient. I need to make it so that the list in the SubCategory changes depending on what is selected for Category. For example, for camping Category, you'de see only tents, sleeping bags, etc for the SubCategory.

I hope I've explained myself clearly. Anyway, what I'd like to know is, how do I do this? Is it possible, even? I'd appreciate any info you can provide.

Thank you for your time,

Ron

[mr_vodka]

Hi Ron and welcome. You mihgt want to start by taking a look at This Thread .

[WCP]

Thanks for the reply.

Unfortunately I'm using FM5, so I can't open any of these files. Is 'conditional value list' the common term for this sort of thing?

[mr_vodka]

Yes. There should be more examples of it done in FM5/6 that you should be able to find.

[WCP]

I've looked, and I can't find anything. Or at least, I find tutorials that I don't understand - I don't know much of the terminology used.

If I had a simple example of a conditional value list, in a Filemaker 5 file, I'd probably be able to figure it out. Does anyone know of or have such a file?

[SlimJim]

The following thread might help, and there is a sample fp5 file in it.

http://fmforums.com/forum/showtopic.php?tid/81246/post/81246/

[WCP]

Thanks!