Copy data between tables
I am new to FileMaker so I'm still trying to feel my way around. I'm familiar with databases in general and have a long history with MS Access.
I am converting an Access database into FileMaker and have figured out the Import function as best I can. I have a Contacts table that I have imported into the Contact Management database template that comes with Filemaker. I am trying to separate my Notes field and move it to the Notes table. Currently, there are 60k records in the Contact Management table and 60k blank records in the notes table. The ID fields were not populated during the import and FM does not give me the option to import directly into Notes.
How can move my notes data from Contact Management table to the Notes table?
I am using FM Pro Advanced 10.0v3.
Thank you in advance, any help will be appreciated.