mac Multiple use of ID not matching with import or related table

[kbeiderman]

Hello,

I hope I will be able to explain myself well enough to get your help. I have a simple table [Log Entries] with student names, their unique ID numbers, discipline incident date, discipline type, consequence, date reported, and reported by (teacher's name). I want to match the ID numbers with Grade Levels I have from a different source. I want to either import table from file and match or I can relate them somehow. 

Here's the problem. Each record could have duplicate IDs but are unique from each other. Therefore, when I try to match for Grade Level, I get no matches. I think it's because the ID is used multiple times, but I don't know how to correct the problem. 

Using a key field could be the solution. I understand how to create a unique key field (auto-enter serial number), but I don't know how to match that with the other file which uses the ID numbers as identifiers.

Thank you in advance, Kim

[bcooney]

Do I understand you correctly? You've received data from another system and wish to report on it using FileMaker? What fields are in the grade level source?

 

My first impression is that you'd have these tables:

 

Incidents - which has a student_id foreign key and a teacher_id foreign key from the people table.

People - students and teachers, each record has a unique to the table ID. Students would have a value in an attribute field, grade level.

[comment]

This part is confusing (or should I say utterly unclear?):

 

 

Each record could have duplicate IDs but are unique from each other. Therefore, when I try to match for Grade Level, I get no matches. I think it's because the ID is used multiple times, but I don't know how to correct the problem.

 

Could you explain this in more detail, perhaps with a simple example?

 

--

P.S. Please don't fancy up your posts with fonts and colors; the default settings are already difficult enough to read, thank you.