can you merge tables?
I've created 2 tables with many fields, and I now realize they belong in the same table. Is it possible to merge the two into one?
Sorry. You can create the fields in the table. Then go to the layout of a TO where you want to import into. Then choose File --> Import. Select the same file that you have open. Choose the other table as the source and use the import option of 'Update matching records'. It will make you designate what fields you want to base the match on.
So yes you can.
It sounds like you're saying no, correct?
You're saying copy and paste the fields in the Layout? and just have the 2 tables remain separate with a relational ID?
(I'm using Filemaker Pro, not FMP Advanced)
If you have FMP advanced, you can copy fields ( or groups of fields ) and paste them into another table.
Without advanced, you can at least copy the calculation expressions one at a time.
Retrieving data ...