cj247 Posted April 27, 2004 Share Posted April 27, 2004 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 More sharing options...
-Queue- Posted April 27, 2004 Share Posted April 27, 2004 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 More sharing options...
cj247 Posted April 27, 2004 Author Share Posted April 27, 2004 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now