Jarvis Posted August 5, 2007 Share Posted August 5, 2007 I'm not sure where to post this so I thought I would start here. I'm trying to produce a layout that shows field names in a column and record values in a grid, similar to a spreadsheet. The attached Jpeg shows what I want it to look like. Is there a way to do this from a portal view? Thanks, Jarvis Grid.zip Link to comment Share on other sites More sharing options...
Fenton Posted August 5, 2007 Share Posted August 5, 2007 What are the columns? Link to comment Share on other sites More sharing options...
Jarvis Posted August 6, 2007 Author Share Posted August 6, 2007 Hi Fenton, The columns with text are field labels: The values with numerals are cabinet numbers (record values). What I am essentially trying to do is produce a Table View except that I want the field names to array in a column on the left and the values to array in a spreadsheet-like format to the right of the field value column. Any ideas how to do this? Jarvis Link to comment Share on other sites More sharing options...
Fenton Posted August 6, 2007 Share Posted August 6, 2007 This is not easy to do in FileMaker. FileMaker is not a spreadsheet. What you are basically asking it to do is transpose, turn everything 90%. FileMaker does not have such a command; it goes against its basic structure; it is a logical structure, not a "positioned" structure like a spreadsheet. You cannot just "switch" its records (rows) and fields (columns). So you have to create an artificial structure that will allow to show things that way. It's hard to explain. Take a look at this site for a method using repetitions. http://edoshin.skeletonkey.com/2006/12/crosstab_report.html Otherwise it can be done relationally also. But that means a relationship for each column. You still haven't told us what your records really are. I know that you'll put text labels in the header, but what? "Cabinet numbers" is still a little vague to me as a description of records. Do you want a column for every single record? If not, then how do you want to "group" the results for columns? What is the concept of what you want to do? Link to comment Share on other sites More sharing options...
Søren Dyhr Posted August 6, 2007 Share Posted August 6, 2007 But that means a relationship for each column Why not just one and an extra TO sanwiched in between: http://www.fmforums.com/forum/showtopic.php?tid/176396/post/204083/hl//fromsearch/1/ ...the problem with multiple relations is, that they are getting slower by the number of them. No - just cut the portal up and rearrange the portalrows in layout mode. FileMaker is not a spreadsheet What is this, have spreadsheets been over-drilled, in the american schools ...we're indeed been getting our fair share of this assumption lately??? --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6243 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 accountSign in
Already have an account? Sign in here.
Sign In Now