I am using Filemaker Pro 11. In my database I have two tables named "contacts" and "agreements." In my "contacts" table I have an "agreement" tab were I would like to display basic information to about an agreement. So if the name is the same on both tables I want the information from "agreements" to display on "contacts in a list view. I also would like a button on each row so that if I click it I am able to go to that record in "agreements" and view the information in depth.
Any help is greatly appriciated. Let me know if you need any additional info. Thanks in advance.