Two different contacts from same table
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).
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?