•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 423,008 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,922 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 2357 | Replies: 2
 |
•
•
Join Date: May 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Access subforms and Filemaker Pro 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.
•
•
Join Date: Jun 2006
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
•
•
Join Date: May 2006
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- filemaker pro 8.5 and php (MS Access and FileMaker Pro)
- Mac or Windows? :p (Techies' 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)
- Dynamic websites with FileMaker Pro (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Dynamic websites with FileMaker Pro
- Next Thread: Filemaker Pro - Multiple File Importing
