To display data from two records in your table at the same time, you'll probably want to use either a table or list view layout to display your data. To find two apparently unrelated records, set up a find with separate "request" criteria for each record.
Enter find mode
Enter data to find the doctor (their name perhaps)
Select New Request from the Records menu
Enter data to find the lawyer
Click Perform find.
Thanks for getting back to me. I may have been unclear about what I'm trying to do.
I have one table "clients" and another list "contacts". On each client form I want to be able to display information for their contacts. I use the same 15 contact a lot so I want to be able to choose the name (or id) and have all of their information fill in automatically. I was able to do this part....
The problem arose when I tried to put 2 contact on the same client form. They always show up as a duplicat contact rather than letting me use two seperate contacts. I'm sure this has to be possible....
Just to clarify, I thought of another instance I need to use this same feature:
If i have a diagnosis table, and within that table other information such as symptoms.
On each client form, I might want to add multiple diagnosis and have the symptoms displayed.
You don't indicate what relationships you are attempting to use. The simplest method is to relate your data by a serial number field and use a portal to display multiple related records.
Your relationship might look like:
Clients::ClientID = Contacts::ContactID
On a layout that refers to Clients, create a portal that displays records from Contacts. For more about portals and table relationships, look up portals in the filemaker help system. For more about making posts to this forum, see: When requesting assistance on this forum...