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.