Database Fields Relationship

Hello to all! Hope you are doing well :slight_smile:

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.