display 1500 fields

[Salin]

Hi There,

I have created a database from a data file with 1500 header names. Now I want to display all them in layouts so that I can see the field names and reorganize them. Is there a way to grab a group of fields and put them in a layout instead of dragging one at a time?

Thank you for any help!

-Sal

[LaRetta]

Hi Sal,

Unfortunately, FM will not allow multiple selection of fields for placing on a layout from Insert > Field or dragging but your opening layout should have all fields on it (view in Form view). Otherwise, when you create a new layout, you can Move All to your layout. Do not use table view for viewing all fields because they will not all display in table view (I think max height and width is 1800 px each direction).

Edited June 15, 2010 by Guest

[Salin]

Thanks LaRetta. You're right that there is an opening layout #1 which include all 1500 fields. However, this layout puts all field names first and follow by all fields. For example the first field name and the first field are separated by 1499 field names. I tried to use Form view only or list view only or Table view, that didn't change the layout.

There is also another opening layout #2 with 442 fields, which is nicely layout out each field name and its filed on each row. That makes it so easy to copy and paste a block of fields. Maybe FM could only show the first 442 rows, so I moved a big trunk of fields to the top right and hope the rest of fields would appear. But they don't.

Any suggestions that I could get the layout #1 to display each field and its name in a row?

Thanks

Sal

[Salin]

OK, I found a solution...create new layouts using the standard form, highlight a trunk of fields and move them over to each layout. I can now see all the fields.

Cheers,

-Sal