Conditional Pop-Up Menu

[cj247]

I'm confused as to why this is so tough, but I seem to be going around in circles with this dang conditional pop-up menu.

I on the one hand have a movie database that has movies divided into "Current" and "Archive." On the other I have a theater database where I want to have pop up menus containing only the "Current" movies.

Seems like I want to have a 1). relationship where I find all the movies, and then 2). a value list where I trim out the "Archive" movies. But I seem to be running around in circles getting either nothing in the list or all the movies in the list.

Any help would be appreciated. Thanks so much...

[-Queue-]

In Movie, create a calculation number field fCurrent equal to type = "current". In Theater, create a calculation number field constant equal to 1. Relate constant to fCurrent. Then create a value list Current using values from field, Only related values, constant_to_current relationship, movie_name field.

Replace type with the field used to hold Current/Archive and movie_name with Movie's name field.

[cj247]

Nice.

That was exactly what I was looking for, just got a little lost in the relationships/value lists forest there.

Thank you so much.