I’m developing an app for teachers in my school, to facilitate the process of tracking students’ infractions.
I created a simple page (page1) with different input forms (search box to choose a student name a simple input box to choose a date and time and a dropdown to chose infractions). The student name is coming from a database (I’ll call it A for this purpose) and the infractions from a second one (B). All this is going to database C.
I want to create a second page with a repeating group (page2) where each teacher (current users) can see the infractions that were given only to the students they advisee (on database A - there are two fields: students names and their advisor names).
In other words, if the current user is also the advisor of one of the students that were issued an infraction by other user (database C) the current user is able to see that information in page2.
Because the information that I want to show exists in two different databases (A and C) I haven’t found a way to do it because I don’t know how to relate both in the same repeating group.
Can someone help me figure it out how to do this?
Thank you so much,