eesh, first - I wouldn't add a second table for that purpose. I would utilize an "archived" flag field or some-some. Secondly, FMP Advanced will allow you to copy and paste tables/fields in a flash.
I would highly recommend you check out the FileMaker database course at Lynda.com. Going forward, it will be extremely useful and help save you lots of DB design headaches.
a bit more - you only need one copy of Advanced for the developer - not the end users.
fmpdude wrote:[...] save you lots of DB design headaches.
[...] save you lots of DB design headaches.
When your table has 300 fields, they have only just begun.
"I currently have a Database with one Table consisting of approx. 300 fields."
Already a disaster. I'm joining those who have already sent the same message.
Stop. Take the classes. Find some way to get somebody else involved who understands database design and who can look at your file, and who can help strongly reinforce the lessons about data structure that are available to be learned in classes and relevant books.
to add to Bruce's note ... it might actually be fun to rebuild. Maybe I'm an anomaly.
To answer your question, to copy fields from one table to another, select one or more fields, then copy, move to the new table and paste. However, I do not recommend that you do so in this case. The description you've given makes it apparent that you are going about things the hard way. Look around on the web for some beginners course in FileMaker. When you get the hang of it you'll find that it is very easy.
Agree with David.
Just rebuild with a real ERD tool!
Take a look at SQL Editor. It connects to YOUR LIVE FILEMAKER DATABASE.
Once you create the ERD, the tool will CREATE YOUR FILEMAKER DATABASE
Don't for a second use the "Relationships" graph as an ERD tool. That would be frustrating.
SQLEditor: Product Support
(There really are no shortcuts to a good design. Jumping in and "doing stuff" only works for a little while until you start thrashing, staring over, tearing your hair out, etc... Think: "Construction metaphor" Read: "Code Complete" and other books.
Try the Lynda.com FileMaker database design course.
But don't hack together any database and expect production results.
(If you have a single table with 300 fields, that, to me, screams "resdesign")
HOPE THIS HELPS.
Retrieving data ...