AnsweredAssumed Answered

Name Lookup with Multiple Table Occurrences

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

Title

Name Lookup with Multiple Table Occurrences

Post

     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?

      

     Thanks

Outcomes