 |  |  |  |  |  |  |  |
Access subforms and Filemaker Pro
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I am trying to do something in Filemaker Pro that I could do easily in Access with a subreport.
I have a table with the fields (student ID, subject, course number, course name, grade, CRN, semester, credits). In one section of the report, I want to list all records with the subject "BIO" which are intro courses, in another section records with the subject "BIO" which are advanced courses, etc...
In Access, I would simply do a query or filter something like this:
[Course number] In ("BIO 110","BIO 111","BIO 198","BIO 112","BIO 113")
Ideas? I am new to Filemaker Pro and this forum.
I have a table with the fields (student ID, subject, course number, course name, grade, CRN, semester, credits). In one section of the report, I want to list all records with the subject "BIO" which are intro courses, in another section records with the subject "BIO" which are advanced courses, etc...
In Access, I would simply do a query or filter something like this:
[Course number] In ("BIO 110","BIO 111","BIO 198","BIO 112","BIO 113")
Ideas? I am new to Filemaker Pro and this forum.
You would accomplish this in FileMaker with either sub-summaries or portals, depending on your presentation needs.
A subsummary is a part which is used to separate groups or records created by a sort order. For example, if you had millions of records of individuals' addresses and sorted by their STATE, then this naturally creates groups of records with with all the AL's together, followed by AK, AZ, etc. If you add a "subsummary by STATE" part to the layout, then this part can be used to force a page break, print headings, report subtotals for each state, etc.
A portal is a view into a table. You would use relationships to specify what filters, if any, would be applied. For your example, you might have two portals, one filtering based on basic courses, and the other filtering based on advanced.
There are other methods to accomplish what you like, but the Portal and Subsummary are probably your best starting point.
A subsummary is a part which is used to separate groups or records created by a sort order. For example, if you had millions of records of individuals' addresses and sorted by their STATE, then this naturally creates groups of records with with all the AL's together, followed by AK, AZ, etc. If you add a "subsummary by STATE" part to the layout, then this part can be used to force a page break, print headings, report subtotals for each state, etc.
A portal is a view into a table. You would use relationships to specify what filters, if any, would be applied. For your example, you might have two portals, one filtering based on basic courses, and the other filtering based on advanced.
There are other methods to accomplish what you like, but the Portal and Subsummary are probably your best starting point.
Thanks very much for the hint - I'll try it out!
•
•
•
•
Originally Posted by MerryOtter
You would accomplish this in FileMaker with either sub-summaries or portals, depending on your presentation needs.
A subsummary is a part which is used to separate groups or records created by a sort order. For example, if you had millions of records of individuals' addresses and sorted by their STATE, then this naturally creates groups of records with with all the AL's together, followed by AK, AZ, etc. If you add a "subsummary by STATE" part to the layout, then this part can be used to force a page break, print headings, report subtotals for each state, etc.
A portal is a view into a table. You would use relationships to specify what filters, if any, would be applied. For your example, you might have two portals, one filtering based on basic courses, and the other filtering based on advanced.
There are other methods to accomplish what you like, but the Portal and Subsummary are probably your best starting point.
|
Similar Threads
- Dynamic websites with FileMaker Pro (MS Access and FileMaker Pro)
- filemaker pro 8.5 and php (MS Access and FileMaker Pro)
- Mac or Windows? :p (IT Professionals' Lounge)
- No Access to Administrative Tools in WinXP Pro (IIS, Services, MMC) (Viruses, Spyware and other Nasties)
- No Access to Administrative Tools in WinXP Pro (IIS, Services, MMC) (Viruses, Spyware and other Nasties)
- Filemaker Pro - Multiple File Importing (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Access Linking a Form to a report
- Next Thread: Filemaker Pro - Multiple File Importing
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
