There is no functionality like in Excel, where you can select individual rows and copy/paste them.
The simplest solution is to use Export Records / Import Records.
You will have to mark the records you want to import, export them in csv or tab delimited and import into another table. You can automate the process with scripting
You can also export as FileMaker file, if it is easier.
You can also import directly between the tables (no need for an external export). The only restriction is you can't import a table to itself, but using the same FileMaker file to import from one table to another works fine.
You can also import directly between the tables
This is true, Mike, and I thought about it as well, but OP wants to copy a number of records and not the whole table. When you import directly you do not have control over which records to import.
My mistake, Mike is correct - if the source file is open only the found set of records will be imported
Sure you do. Just do a Find in the source table prior to performing the import.
Just do a Find in the source table prior to performing the import.
My bad, it works fine. I tried it with a two files setup and the source file was closed. This is definitely the easiest way to copy records across.
Thanks to Nicolai and Mike for your advice.
Otherwise, I can suggest the person to create a third table with the fields A and B linked to the other two tables. With some flags I can show or hide the records and the person thinks to copy records while nothing realy happens.
That is a better solution from a data standpoint.