AnsweredAssumed Answered

Name Lookup with Multiple Table Occurrences

Question asked by TurtleKoala on Oct 2, 2012
Latest reply on Oct 2, 2012 by philmodjunk


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?