1 Reply Latest reply on Oct 22, 2014 7:20 AM by philmodjunk

One drop down leads to specifics in the next drop down...how to?

james211 Oct 21, 2014 8:54 PM

Title

Post

Sorry for the idiot question as I'm new to filemaker. I'm creating a coffee database for green coffee. I have a couple of drop downs and I'd like for one of them, the country to then have the next drop down reveal drop down entries specific to that country...does that make sense?

So if I select Ethiopia in the country, the variety dropdown will then only show varieties specific to Ethiopia. If I select Brazil, it will only show varieties specific to Brazil.

How would I do this? Is it a relationship thing? Portal?

1. Re: One drop down leads to specifics in the next drop down...how to?

philmodjunk Oct 22, 2014 7:20 AM (in response to james211)

This is called a conditional value list. Here's a link to a free exploration file that illustrates 8 different ways to set up a conditional value list. What you describe is simply the basic conditional value list:

https://www.dropbox.com/s/oj15fqp1uakg0d7/Adventure%201%20CVLs.fmp12?dl=0

There's also a link at the end of this file to the second issue which explores the concept of what to do when a simple value list, conditional or otherwise, isn't sufficient.

Caulkins Consulting, Home of Adventures In FileMaking
Like Show 0 Likes(0)

Actions