how many fields do you have in your layout ?
Are there someone on the header part or footer part ?
Thanks for your response, Daniele.
In the mysterious way these things work, I had tried everything I could think of without success, then posted my question and went to get some lunch. When I came back, I found your reponse, but also that my table view is now working perfectly! The last thing I tried before leaving my desk was to resize all the columns smaller. Could this have fixed it? Is there a maximum width for display? A maximum number of fields for display?
I have 100 fields, 91 of which are included in this layout, all in the body. Was this just a glitch or was it something I did?
> Is there a maximum width for display? A maximum number of fields for display?
Yes, the layout has a fixed widht.
With a column width of 100 pixels, FIleMaker can display only 80 fields ( or about that number ) in Table view due to the width of the Layout.
Thanks for helping me understand my problem- I was having the same issue you just responded to.
SO my question is, so what should I do if I have 150 fields to display in a table?? Do I need to create separate tables that are related? This would be quite cumbersome for data analysis.
Please let me know if you have a suggestion.
Thank you for your posts.
I would create two different layouts. One with the 80 fields, and another with the remaining 70. On the second layout, you could include the first five fields from the first table, so when you switch between the two tables, you have some consistency. You can even create a button that will switch you between the layouts.
I hope this helps.
I am new to this forum and haven't yet found how to start a new query, so I apologise for tagging my new query on the end of this question on a similar matter.
In Access and Excel it is possible to 'freeze panes', ie keep a column or columns 'frozen' to the left hand side as well as heading(s) at the top, enabling the user to scroll to the right and down, whilst still being able to see which data it refers to.
Is there some way of doing this in File Maker Pro 8.5? I have got column layouts and also I've been looking in a table view of a form but I have not seen a way of doing this.
If anyone can help, that would be great.
Many thanks and kind regards
Thank you for your post.
Freezing a field/column in table view is not possible with FileMaker Pro 8.5.
To start a new message, go to the board you want to add the message, and in the upper left corner, just above the first topic, there should be an icon that says "New Message". Click that icon, and you can start a new thread.
Hi Suzy, it can easily be made to look like Freeze Pane by using technique above. The fields far left that you want to freeze, have them appear on both layouts. Then change your table layout by adding a header ( Layouts > Layout Setup and selecting Views tab and table views properties and select Add Header). In this header, put a right-pointing arrow at the top right of the layout which switches you to second layout. And on second layout, put left-pointing arrow at the top left of the layout which switches you back.
Make your 'frozen' first few fields a slightly different color (maybe same as header). Then, to your Users, it will appear that the arrows jump the unfrozen part of the body back and forth.:smileyhappy: