Layouts with fields from two databases
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