Converting A Flat File To Relational

[Texarado]

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!

[Fenton]

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.

[Texarado]

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?

[Genx]

Yes

[Ender]

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).

[bruceR]

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.