Auto Cascading Selections
Here is the simple gist of the idea. Their is a userType table, users table, and a company table. I already know how to get cascading selectiong working (
1. select this company ->
2. these people show up -> select person ->
3. their available types show up).
However, what if I wanted one drop down selection that started in the middle of those three steps? Say on a part of layoutA I only wanted the user the option to view only the "graphics usersType" users? We already know that this record is attached to a certain company, so that is already selected but...yeah, how to constrain drop downs to certain users by "auto selecting" of sorts items higher up in the selection process.
Hopfully this makes sense! Thanks.