I have users that may fall in two types: Students and Professors. Both may log to the app, and each has it’s own profile. So Students profile and Professor profile tables are connected to user.
If Professors can search students and select some of them with a search criteria, I may create a selected Students table connected to Professors with an action link, and connect to user with a rule. But how to connect “selected students table” to students and professors at the same time? This way I’d be able to show details of student and Professor. But connecting to user does not allow that option.
It’s easy to input manually student and professor with a form. But how to register the conection to two tables?