You should be able to add datasources in the Relationships Graph as tables and use them on layouts just like any other table.
Could you be a little more explicit. I'm new to FM. I can see my datasourses in the Relationships. I know how to link keys together but this doesn't allow me to see all the records in the external datasourses...
Create a layout with one of your external datasources as the primary table
Then you can add a portal to show all the related records from the second data source
Similar problem. I am trying to use a table of addresses in one FM file (A) in a second FM file (B) so I will only have one table to keep updated.
I inserted a popup menu using the values from the field in file A and I can select the address from that Table ok. I also added the table from file A in the Relationships & can display other fields from that selected address.
I also want to be able to edit the Table from both file A & file B. So I need to display all file A addresses in table form in file B for editing while in File B.
I have not figured out how to display tis table except as a popup or drop down list.
Is there a way to show the External Data Source as a table in the file B?