Jump to content
Sign in to follow this  
cj247

Conditional Pop-Up Menu

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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Nice. laugh.gif

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

Thank you so much.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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