I have a database with 2 tables. One table (Student Table) has all students in the county and their current information. The other table (Encounters) has individual encounters for that student each year. As we make encounters we need to keep the year the encounter happened data (school, grade) with it. I have created lookup fields to address that situation and it pulls in the data.
Here is the problem. I need to be able to have a value list created from the Student Table when I am creating a record in the Encounter Table. We need look up from a non-unique field. Currently can look up one occurance of lets say John, but not all occurances. Need them in the drop down list.
Can someone help me?