I am new to FileMaker, so forgive the ignorance with this question. I am creating an archival database and am having issues linking two records in different layouts. I have two tables: Table 1 lists all the archive information, Table 2 is a contact database of the designers referenced in Table 1. The "Designer ID" in Table 2 is linked in a relationship to the "Designer ID" in Table 1. I want to have a record from Table 1 in a layout be a button that takes you to the contact card for that designer in a separate layout (with Table 2).
I have tried scripts that use Go To Related Record or Go To Layout with Perform Find. But I don't think I am going down the correct path, or I am missing a step.
Any help would be greatly welcomed!