Using File\Import records\File... to open an .fmp12 file what does it import? All the records existing in the selected file?
Can you please elaborate a bit?
The same file can have many tables storing data for different purposes. Sometimes there's a need to copy a block of records from one table into another and import records can do this just as it can import data from a table in one file into a table in another.
Note also that you can set up an external data source reference to a table from another file with a table occurrence based on it. Then you can use import records to import data from or into that table in the other file just as though both tables are in the same file. This can make the scripting a bit simpler in some cases.
Just opening the file doesn’t import anything.
Import records can be used via script or menu option to import the records from one table into another. If the source file is open at the time you import, you open a found set. If it is not open you import the records from the entire table.
To learn more look up import records in Help.
The Import and Export works with the found set. this a link to the Help for Import File
FileMaker Pro 16 Help
I think the best way for you to discover would be to try. But to answer your question you always import into a FileMaker table, so if the file you are importing is a FileMaker file, it will have one or more tables in it. The first screen that will popup will ask you to choose the origin table (imported) and the destination table, then you will need to do what's called mapping where you shuffle (if need be) fields around to import one origin field into a destination field.
Your post gives me the impression that you are doing this from with the same file, if so, you will probably need to export the data and Import it to the other Table.
Importing the data from one table to another in the same file does not require exporting.
Why would I want to import from the same fmp12 file as the one I have open? Did I misunderstand your wording?
Wow, I have never tried that.
It's a great day when learn something new.
Retrieving data ...