Forming New Layout from Three Existing Layouts
I'm relatively new to FileMaker, so pardon if this is a pretty basic question. Essentially I uploaded three spreadshsets to FileMaker. Each of the spreadsheets share a name field, though not all the names are found across each spreadsheet. I figured out how to establish a relationship between two of name fields (File > Manage > Database > Relationships), and I'm guessing establishing a third relationship would require just linking the additionally name field to the previously linked name fields.
Each of the spreadsheets contain similar, though not the same information. Spreadsheet 1 may have Name, City, State, while Spreadsheet 2 may have Name, Email, City, State, Zip (again, there are names found across all three spreadsheets). I was wondering if there was a way that I could generate a layout that would have the linked names from spreadsheets 1, 2, and 3, plus all the unique information associated with each name in each spreadsheet.
Hopefully this was clear. Thank you in advanced for any support.