Name Lookup with Multiple Table Occurrences
I am trying to create a name lookup for a database with an Employee table and a number of related tables. The two that I will focus on are Feedback and Projects. I am basing the name lookup on PhilModJunk's SimpleNameLookupDemo. I am creating two occurences of my Employee table, one which links to the other tables by Employee Name, and the other which links by a surrogate key. This works well when I use the lookup for a single table, but when I try to use it for two tables I get the error that says that there can not be more than one relational path between any two tables in the graph.
Is there a way to tell it to let me to do this?
Do I need to create a new table occurrence of Employee for each name lookup?