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
Reply

Join Date: May 2006
Posts: 2
Reputation: leba is an unknown quantity at this point 
Solved Threads: 0
leba leba is offline Offline
Newbie Poster

Access subforms and Filemaker Pro

 
0
  #1
May 24th, 2006
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.
Reply With Quote Quick reply to this message  
Join Date: Jun 2006
Posts: 4
Reputation: MerryOtter is an unknown quantity at this point 
Solved Threads: 0
MerryOtter MerryOtter is offline Offline
Newbie Poster

Re: Access subforms and Filemaker Pro

 
0
  #2
Jun 5th, 2006
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.
Reply With Quote Quick reply to this message  
Join Date: May 2006
Posts: 2
Reputation: leba is an unknown quantity at this point 
Solved Threads: 0
leba leba is offline Offline
Newbie Poster

Re: Access subforms and Filemaker Pro

 
0
  #3
Jun 5th, 2006
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC