I have three fields: Login - which uses a single line field that will take a value and evaluate it using the if condition; Association Selected - which will be populated, based on the Login field if statement; and Candidate - that will filter a database list from another form and only show those records that meet the value of Association Selected.
The first half works (using a login value to set the value of Association Selected), and the second half works if I type in the Association name in Association Selected, or pick it from a drop down. However, I can't get all three pieces to work the way I need them to work.
When a user enters a value in Login, I only want their association to appear in Association Selected, so that that value can be used to filter Candidate.
Really need help here. Thanks!