Table Layout, but need a new page for a change in a Specific Field

[Darth Pooh]

I suppose the title says it all.

I have a table layout mode. It includes some information about a student and I want to print out several tables according to one specific field, each table having it's own page with the matching fields.

Can this be done? I find that the Part Section is fairly confusing if you haven't used it before and I think I need a fairly clean explanation on how to do this, I keep thinking it might be a script I have to create but again, I am not even sure.

Thanks!

-Keith

[bcooney]

Investigate creating a subsummary report.

[Darth Pooh]

While I greatly appreciate a response... telling me to SEARCH (when I have done this ALL morning) is fruitless. The reason I say that is because I feel that my knowledge of FM is limited in the sense of the language they use. For instance, Sub-summary to me would just produce a count and not a break by change in field. I've searched this forum and countless others, but I think sub-summary might be TOO vague and broad for my purposes.

Also, I know this might be an easy question and even easier to solve for an expert, I am not one of those people. I am not an idiot either... so while I appreciate your effort, it wasn't necessary to tell me to go search something out. That was like you asking me for help on Integrals and I tell you to go do a search on Calculus.

Edited October 17, 2008 by Guest

[comment]

It's difficult to be specific without you being more specific first. I, for one, didn't understand your question at all. Why don't you describe what you have and what you need - preferably in non-technical terms.

[Darth Pooh]

Sure no problem...

I have a file with Student name, ID number, and a few other fields, one of which is a course code for each record. It is currently set up in Table Layout and I want to print or even view in Preview Mode, separate tables based on the course code the student is enrolled in. So there are currently 16 different courses a kid could have, I want 16 different tables (basically a class list). Currently, it is listed as one long list sorted by those classes. I'd also prefer to hide the course code field from showing up on the Table view.

Sorry that it wasn't clear. I am obviously not an expert at this.

[comment]

It's not yet clear now. I don't understand what you mean when you say "table". In Filemaker, a table has a very precise meaning. If you are in version 5, and you have one file, then you have precisely one table. However, I don't know a table "of what". If there is one record for each student, then that would be a table of Students.

there are currently 16 different courses a kid could have

How are these assigned? Do you have 16 fields for course assignment, or what?

I also don't understand the exact form of the report you want. Why don't you write out an example.

[bcooney]

I apologize if my answer seemed dismissive (usually I'm long-winded). I truly thought that if you read up on sub-summary reports, you'd see that it is probably part of what you want. You'd end up with a list, separated by student (one per page, perhaps.

But as comment further explains, we need to better understand the design of the report that you wish to achieve. Once we know that, we'll work backwards to confirming that you have the necessary data structure.

[Darth Pooh]

Thanks for the help guys! I really appreciate it!

Ok. So each record consists of imported data from Excel.

It has their ID number in one field, Name in another, grade in the next, etc etc. One of those imported fields is a course number. I have it setup in a table layout. So when I go to Preview Mode, it looks like it would in Excel in a table... What I want to do is basically print a page by the course number field. So if 30 kids have a course number in a certain field, they show up on the page within that table view. I would like to do that for all 16 possible courses that I know a kid could have.

Does this sound right? I might be calling things by the wrong name here.

EDIT: I might actually just EXPORT this all to EXCEL and then print it that way (using a filter). I was just hoping I could keep it contained within the one file I already created with the second layout in table mode.

Edited October 17, 2008 by Guest

[bcooney]

Here's a demo of a sub-summary report by course. The import from Excel is a drastic difference, because you seem to be just using FM for its reporting.

If it's possible to use FM for creating the data, your data model will change. You'd have a table for Students (one record for each), a table for Courses (likewise) and a table that joins Students and Courses (Enrollment).

StudentRoster.zip

[Darth Pooh]

I basically used FM for a layout to idea. The kids are changing courses in a few days and I wanted to give them a letter saying which course and room to go to. I used it like a merge almost... but I liked the layout flexibility of FM over Word. I imported some fields and did calculations / relationships with some others.

I think EXPORTING into a new Excel to make the new combined lists is probably a better idea at this point.