While this can be made to work, why did you create two separate files?
What you describe here are two different tables and these can be defined in the same file--which is an easier approach for new developers than using separate files.
You can use Import Records | file with "new table" selected in the target table drop down to import the entire table from one file to another.
Or you can go to Manage | Database | Relationships, click the button at far bottom left and select "add fileMaker data source" to select the table from your other file. This sets up a new table occurrence linked to the table in your other file.
Either way, you now have two table occurrences, one for each table in Manage | Database | relationships and now you can link the two in a relationship matching records by student ID. This will then enable you to put a portal to your attendance data on your student layout to show all the attendance records for that student.
Thanks for the quick answer. There are two files because that's the only way I can export them from the school district's mainframe. I'd love to be able to have it as one file so I can mail merge it in Word to send home postcards to parents that haven't sent in absence notes. I'm new to the program, but I see endless ways for this to make my staff's jobs a little bit easier!
I probably should have tried what you meant before posting my reply. I see what you mean with scenario 1 now that I tried it. I have 1 fmp file with two tables that were created from the 2 csv files from the mainframe. Took me a minute, but I got your meaning. I linked the two student id files under table relationships.
Now, and I feel like an idiot for having to ask what I suppose is a obvious thing, but how do I make a portal? What is it?
My goolefu is apparently getting better. I found the portal directions online. Works great!
Thanks again for your help!