Maximum number of fields, or Bug?

[Gwen]

Hello. I am new to FMP (7.0v2, MAC 10.3.6 platform). I have constructed a table that currently has 80 fields successfully defined. All 80 fields appear correctly in the Browse mode. However, when I define an 80st field, there is no error message, but it does not appear in the Browse mode. Is there a max number of fields per Table, or is this some kind of bug?

Thank you in advance for your help!

[Ender]

There is no 80 field limit to FileMaker. Can you manually insert the fields on the layout?

[Reed]

I think that you must be running into FMPs limit on how wide a layout can be. Are you viewing the layout as a table? Try viewing as a form and see if the fields appear that way.

The only way to get more fields to show in table mode is to make each field narrower.

[Gwen]

Thanks for your replies. I'll try both of these things and let you know what works.

Best wishes,

Gwen

[Gwen]

Hi Reed. The field did indeed show up in Form view, but the fields are all out of order. How do I specify that I want the fields to appear in the same order as the "custom order" in which they appear under Define > Fields, and to appear in that same order for all Views. This seems kind of goofy (like it should be automatic...).

Thanks again,

Gwen

[-Queue-]

Custom Order is merely for viewing the fields in Define Database. You have to manually change the order on layouts.