Best way to do multiple looks from same table
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.