Once upon a time, you could only define 1 table in a given FileMaker file. To link the tables in relationships, you had to link the files. Even though we can now put multiple tables in one file, FileMaker still retains the ability to link to tables in other files.
- Open Manage | database | Relationships
- Click the button at far bottom left of this window to create a new Tutorial: What are Table Occurrences?. This opens a new dialog box.
- In the dialog box, there's a drop down for selecting which table will be the data source table for your new table occurrence
- Select "Add FileMakder Data Source". This opens dialog boxes where you first select the file that contains your table and then the table from that file that you want.
- You now have a reference to a table from another file and you can link it to tables in your current file, base a layout on it, use it as the basis for a portal....
- This also will create a external data source reference that you can find in Manage | External Data Sources
- Once you have created one external data source reference to a particular file, you can set up more table occurrences that link to other tables in this file without having to go through the process of finding the file from which you want to select a data source table.
Use FileMaker Pro to open the hosted file and edit them. When selecting a file for an external data source reference, you can click "Open Remote" and find the hosted file on the server. If the file is set to not display in the hosts dialog, you can still click the name of the host and then manually enter the name after the IP address shown at the bottom in order to open the file.
Ok Sir, I will try and say the result soon..