Drop down list based on condition

[muskee]

Hi guys!
I need to make a drop down list depending on a value selected, here is what I have:

Basically I have a database for assets. I need to store the location of where the asset is, depending on the city it may have different factories, so the asset is in one of those factories.

So for example, the city of Miami has 3 factories, when I register a new asset I must pick the city and then the factory in where it's gonna be.

How would I do this with some drop down list?

thanks for the help

[Kris M]

google filemaker conditional value list

http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists

http://filemakerhacks.com/2012/07/25/magic-value-lists/

https://www.teamdf.com/blogs/conditional-value-lists-pt-1-what-are-they-how-to-build-them/

 

[muskee]

Hi Kris, thanks for the reply.

I did the tutorial of the first link, I got it working but on my Factory layout, I can't seem to get it working on my assets layout, i'm not sure if i have to do something else