I am building a component and one of my table is requires 2 foreign key fields, one for each of the other tables. Below if the foreign key (FK) assignments
Polls
Schools - FK Poll
Teachers - FK, Poll, School
What I would like to have is the 'School' list be filtered after the user selects the 'Poll'. Let me if this can be done or will I have to write custom code to get the list?
Also can the conditional fields allows to show if not equal to a option?