Thanks for the tips guys. Embedded view can't seem to get it right, because I have a lot of filters to apply (maybe I'm just missing the point though).

Anyway, I uploaded a test database here: http://www12.zippyshare.com/v/25494649/file.html
 

Thank you so much for your help.

This will not work because Notes cannot know which task belongs to which country. You can make the Country field multi-value and the Task field single-value, OR you can make the Country field single-value and the Task field multi-value. You cannot make both the Country AND Task fields multi-value.

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.