Thank you all, these are proving useful.
I am here to inform you about my progress as I actually managed to achieve kind-of what I wanted.
I created a new form, with a single input field that is a dialog list (it contains the countries), and then I have multiple computed fields:
-
First, I fetch the employees whose main countries are the selected country, and the job descriptions (w. dblookup). I also fetch their serials to a hidden field.
-
Then, in a computed field, I use a rather complex formula to fetch the responsibilities (at least complex for me):
-
I check for each employee found, in which field is the current country defined for them. Then I fetch the responsibilities for that country. (this is done by a field-naming trick, eg. I have stored countries one-by-one as mctry_1, mctry_2 ...; and their respective tasks as mtask_1, mtask_2, ...).
-
Currently, I have a form that can display per country, who are the main and backup employees for them, and what are their tasks for the country.
-
Now I am looking for a method to display all countries in a view, if possible.
I made some screenshots: Country form, Employee form, Result
I can upload the current state, however as it is much easier for me to use actual data than dummy, It would take some time to anonymize the database.