You follow the same steps for importing from a table from the same file as you would for importing from a table from a different file.
Use the File option and when the dialog opens to select a file, select the file that you already have open.
I tried this with a local file and it works. The situation now is that my database is in a remote server (filemaker hosting service).
I've tried the format ( fmnet:/hostIPAddress/filename ) but the tables don't show in the mapping field window.
Click Add File and then click "Open Remote".
I checked with my FM host and we figured out the path.
Instead of a HostIPAddres they gave me an URL that is now working!!
Thanks for your help....
I see the "remote" button now. Thanks!
Glad you got it working. However I must question the utility, in a relational database, of duplicating data that can be accessed from its original source without duplicating it. That's what relational databases do best.
That's a very good point, yet there are times when this is still a good idea.
In some cases, the data being transferred serves as a "template" where, after import, the imported data is further modified and thus there is no data redundancy. In other cases, the import captures a "snapshot" of a set of records preserving the data as found at a specific point in time and then the data in the original source "ages" and is subject to possible future modification--again, no data redundancy.