hello, I am new and I have been struggling. I created a form for list of banks, bank transit and branch. I created three list: Banks, BRANCH&TRANSIT and banks. I got the banks and branche selected to work but I need the transit number to work. I can't get to work. can someone help me. thanks
with the given information we are not able to help.
Could you please elaborate?
What is the transit number? Is it a information in the branch and transit list? In this case a formula like this should work for you:
How are the lists affecting each other? Are you using some sort of cascading lookups which fail?
Have you tried my formula?
"BRANCH&TRANSIT" is the name of the list
[Your_Form_Control] is the form control name for the branch
"TRANSIT" is the Ouput column, I have already changed it from my original suggestion.