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...

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.

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.