Hello All,
I've a problem regarding the creation of a list in a Canvas App. The problem is the following. I have multiple tables.
User, Competency, Department, Competency Department and Category.
Each Competency has a Category (E.G. Competency "French" and Category "Language").
Besides that, each user and competency has a department (through competency department). (E.G User "Martin" is in department "Office" and Competency "French" is one that belongs to department "Office").
Now I want to show a list of categories for a user that has competencies of the same department. But I can't get it right.
Any idea how to fix this?
