I am stuck in a Filemaker Relationship! Pun Intended. :) On previous advice, I created a new Notes table with relationships to our 3 businesses: Sales, Rentals, and Business Sales, as well as to the Contacts table and Agents table. This works fine and I can navigate anywhere through "related records."
However, I tried to get fancy and do the same for the Contacts and Agents (SEE ATTACHED picture of the Relationships diagram). Since they were already related to Notes, FM forced me to create a 2nd table occurrence of each. This caused no problem in showing data via a portal (so long as version 2 of each table was the link). However, when I try to go to the related record, I have nowhere to go since each of my layouts are based on the main table and not version 2 of it. I could create a duplicate layout related to version 2 of the table; however, then I would have to maintain 2 layouts for each table. Is there an easier way of doing this? Thanks.