AnsweredAssumed Answered

Best way to do multiple looks from same table

Question asked by Scott_JPN on Dec 25, 2012
Latest reply on Dec 27, 2012 by Scott_JPN


Best way to do multiple looks from same table


     Hi guys,

     I have a situation where I'm pulling contact details via a look-up. I would like to pull the contact details on more than one occurrence to the same table.

     ie I have contact 1, contact 2, contact 3, etc in table 2 pulling the contact details from table contact. On one layout I pull different contact details up to 10 times.

     For each link I'm pulling contact name, mobile, email address, etc

     Is the best way to do this by adding a table in relationship and joining each table by calling them contact 1, contact 2 , so I end up with contact table attached say 10 times?

     Just looks a bit messy that I need to link contact table 10 times to get the desired result or am I missing something, and this is the only way to do it?

     Looking at streamlining the database and want to avoid unnecessary link tables together if I can.

     So I guess what I'm asking is, is there a way to link the contact table only once, but pull multiple details onto another table on multiple times.