Hello.
I have a solution where there are tables for employees and projects. Every project has many employees attached to it. I'd like to have a portal on the Employee form for all the projects the employee has participated in.
I have tried to add lots of columns to the project table(employee1, employee2, ...) and tried to use multi column relations to connect them to the employee table, but that did not work. Do multi column relations work on an AND or OR principle?
Is there a better approach?
Thanks in advance.
jw