Jump to content

Conditional Pop-Up Menu


cj247

This topic is 7275 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7275 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.