944,133 Members | Top Members by Rank

Ad:
May 24th, 2006
0

Access subforms and Filemaker Pro

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
leba is offline Offline
2 posts
since May 2006
Jun 5th, 2006
0

Re: Access subforms and Filemaker Pro

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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
MerryOtter is offline Offline
4 posts
since Jun 2006
Jun 5th, 2006
0

Re: Access subforms and Filemaker Pro

Thanks very much for the hint - I'll try it out!


Quote 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.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
leba is offline Offline
2 posts
since May 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: Access Linking a Form to a report
Next Thread in MS Access and FileMaker Pro Forum Timeline: Filemaker Pro - Multiple File Importing





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC