1 Reply Latest reply on Dec 23, 2010 9:08 AM by philmodjunk

    "How i insert more than 500 columns"



      "How i insert more than 500 columns"


      Hi Everybody,

      Can anyone tell me how i insert hundreds of columns in File maker file?

      When i inserting more than 500 columns in Filemaker using manage option and  create them then created columns are not showing in the the table previw and application get hanged during this operation.

      How i shown all the columns in the preview and insert records in them........

      Plz anyone can help me.............

                                                        Have a nice day.

        • 1. Re: "How i insert more than 500 columns"

          You can't. You'll hit limits that prevent this long before you get anywhere near 500 columns. You'd need to use multiple layouts--each displaying a subset of the total number of columns.

          500 columns means 500 fields and that seems a very extreme number of columns. It's very likely that a different approach using one or more related tables would be a better option for doing this in a database system such as FileMaker.