AnsweredAssumed Answered

Two different contacts from same table

Question asked by jilldguz on Oct 4, 2009
Latest reply on Oct 5, 2009 by philmodjunk

Title

Two different contacts from same table

Post

Hi there. I'm a newbie to File Maker (10) so bare with me :)

 

I have two tables - CLIENTS and CONTACTS. 

On my clients form, among other information I am trying to be able to show information from two different records in my CONTACTS table(for instance, a doctor and a lawyer). 

 

Contact1:

Name

Phone

Email

 

Contact 2:

Name

Phone

Email

 

I tried to make a relationship between, but every time I choose contact1, it duplicates all of the information into the contact2 spaces also. In other words, I am able to reference the information from the CONTACTS table, but it is not letting me do it uniquely twice. Does that make sense? Any suggestions?

 

Thanks!

Outcomes