My flat file could be improved greatly by converting it to relational.

It contains about 300 fields that I would like to move from the main table to a new table.

Is there a way to migrate fields from one table to another? Recreating all 300 fields in the second table would be very time consuming.

Thanks!

You may not have noticed, but since you have FileMaker 8 Advanced you can just copy paste selected fields from one table to another. Or you can copy/paste the whole table, then remove the fields you don't need. Either way is very fast.

Thank you! I use FMPro 8.5 Advanced at my office, but I'm using 8.5 Standard here at home. Is that a feature unique to Advanced?

Yes

My flat file could be improved greatly by converting it to relational.

It contains about 300 fields that I would like to move from the main table to a new table.

Is there a way to migrate fields from one table to another? Recreating all 300 fields in the second table would be very time consuming.

I don't think you're normalizing enough. Typically, in a normalized solution, you'd have something like 10-30 fields per table (the main entities could have more).

The copy/paste feature is in Advanced only but you can import a table and create a new table based on the import in regular Filemaker.