Title
Layouts with fields from two databases
Post
Is there a way to display fields from two related databases in one layout? I've got the layout set up and the relationships are working but I can only display one set of fields at a time. When I go to "Modify Layout" it only shows the records from the table I have selected in the "show records from" drop down.
Sadly I've been working for a week to get a report that contains data in fields from db1 that is matched with fields from db2 and I'm failing miserably.
Any help appreicated and I will provide whatever other info necessary to troubleshoot.
Thanks in advance
And what is the relationship linking the two tables?
To add a field from a related table while in layout mode, drag from the field tool to your layout, then select the table occurrence of the related table in the drop down at the top of the specify fields dialog that appears. then click the field that you want from the list below it.
To add a column while in table view, click the modify button and then again, select the table occurrence first from the drop down, then select the field or fields that you want to add to your table view.
But the type of relationship you define between the two tables will control whether or not the results are what you need or not. There could be multiple records in the related table that link to the current record on your layout. SInce the above methods can only show data from a single related record, FileMaker shows data from the "first" related record.
If you want to show data from multiple related records, use a portal instead of adding a field directly to the layout.