Display only records where ID exists in two tables, Portal needed?

[welchj]

I'm new to using FileMaker, the version I'm using is FileMaker 9.

 

This seems like it should be simple, and thus, I assume I must be just missing or misunderstanding how to do this. I've looked around the forums under portal & relationships already but haven't found anything, so if someone could point me to the right thread, if it already exists, then thanks.

 

I have 2 tables, a students table, and a dean's list table. The dean's list table changes every semester, and it only contains studentIDs. I have a layout that I've set up that uses the student table data to print a release form for dean's list announcements.

 

I've set up a relationship between the studentID field on the students table, and the studentID field on the dean's list table.

 

The students table holds data for ALL students, but the dean's list table only holds the studentIDs for SOME of them. I need to somehow make the dean's list form letter only print records where the studentIDs exist on the dean's list table.

 

pseudo-sql: SELECT * FROM students WHERE students.studentID = deansList.studentID

 

Something like that. I know it must be really easy, and I've seen many posts that talk about creating portals to access specific fields, but I don't quite understand how to make it do what I want, and the filemaker 9 tutorials pdf is not helpful. Do I need a portal? I'm not even sure how a portal would work to do that.

 

Any help is appreciated, and thanks.

[AHunter3]

Make a layout that looks visually just as you'd like your report to look, with the Dean's List table being this table's native table — so that the RECORDS you end up browsing if you do a Show All Records are Dean's List records — and on that layout put related fields from Students such as student name.

 

No verb (script) necessary.

[welchj]

Ahh, I see. I was hoping it would be possible to keep the student table as the native table for this layout, since the Dean's List tables are going to be coming and going more often. I'll try what you suggest, though, and thank you!

[AHunter3]

Well you can do it that way too: do a Find in Students for related field DeansList::Serial Number > 0; the students not on the deans list will not have a related Deans List record, right? And the ones on it will?

 

It will be a slow find though, finding on related values always is.