Hello to all! Hope you are doing well 
I’m trying to build a teacher referencing app.
The architecture of my app is roughly like this (3 pages):
1 List of courses / Pick the course field (Sport, Music, Ectt) > 2 List of professors for the chosen course / Pick the professors > 3 Get the info of the chosen professors.
My data base is currently built like this:
- Course Catalog (Data type) : Course Name (field) / Course Description (field)
- Professors (Data Type) : Course Name (field) / Professors Name (field) / Professors Informations (field)
The idea would be to be able to link fields that have the same title/content even if their data types are different.
Thus, to be able to cross each stage (1,2,3) by displaying only the linked data.
I tried between 1 and 2, via the addition of parameter to the workflow (via unique id) but in fact, I have no access to the other data type “Professors”.
I would like for the 2nd and 3rd page, to be able to diffuse the “Professors” data while keeping a link with the previous options chosen (Course Name).
Is it a question of linking 2 data types via the similar fields ?
Does anyone have an idea of how to do this?
Thanks in advance for your help.