Is it possible to disable a relationship based on calculation?
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!