Jump to content

Converting A Flat File To Relational


Texarado
 Share

This topic is 5597 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5597 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.