Jump to content

Just can't figure out how to filter this value list

Recommended Posts

Howdy, all:

Well, I've spent the last twelve hours beating myself up trying to get the attached to do what I want it to do, but couldn't; I did manage to utter a unique, fantastical, banquet of curses throughout the day, though.

What I'm trying to accomplish is in the School (and in turn, District) tabs in the Activity_Log layout: I want to have the the user choose a school (using the global field's pop-up menu) and have only the District_Staff names appear in the Name-labeled field's (::_kflt_District_StaffID) value list who not only belong to the chosen school but also have "Active" entered in their respective Status__lxt fields. (By the way, did I set up the relationship correctly for the All (Active Filter) tab to show only active (status) people? It works, but I'm not sure if the way I set it up is a "best practice" way of doing things.)Filter.fmp12

Off to stoke up on some Tylenol--this database has given me a royal brain hernia.






Edited by WF7A
Grammar police
Link to post
Share on other sites

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.