Field Choices and Pop Up Menus

[oscarbum]

Oy. Working on a massive project and one of the things I can't seem to figure out how to do is getting fields to work with each other. This is for a theatre (I'm not a contractor, just someone who works there). We use FMP to do our orders. The way it works now is that we've got a pop-up menu on our orders to choose a show. Then they type in the date and time of the show. What I'm trying to figure out how to do is make it so that when the choose a show from the menu, the date becomes a menu of the dates of the show. Then when they choose a date, the time becomes a menu of the times the show plays on that date.

What's the trick to doing this, please?

Thanks.

[transpower]

The trick is to use the ValueListItems function, so as to choose the appropriate value list.

[Ender]

The trick is NOT the ValueListItems function. The trick is building conditional value lists for each of those fields to choose from.

oscarbum,

Try searching the forums for +conditional +value +list or +dynamic +value +list and look at the threads pertaining to FM 5/6. If you haven't already done so, you'll need to normalize your solution into separate files for Show, Show_Date, and Show_Time.