AnsweredAssumed Answered

Is it possible to disable a relationship based on calculation?

Question asked by rfaintich2013 on May 25, 2013
Latest reply on May 27, 2013 by rfaintich2013

Title

Is it possible to disable a relationship based on calculation?

Post

     Hi!  Is it possible to disable a relationship between two tables based on a calculation?  

     For example, I have a multi-relationship set up between a couple of fields between tables....  (based on Athlete's name, Level, Season)  

     This works terrific when I want to see only the stats compiled by that athlete during a particular season, at a particular level (Varsity, JV, etc...)

     My question is, there is a drop down menu, where the user can select the frame of reference, for example, Level....  I want the user to be able to select "ALL LEVELS", but this would mean that I would need to turn off the relationship, since it is impossible for me to have "ALL LEVELS" be an option in the table I'm referencing....  

      

     Thanks for your help!

      

      

Outcomes