autocomplete value from record in table B if values entered into table A match?
I have a table with a list of students, I identify each student using a student ID, i have fields called "Status"; "Program" and "International" there are 16 possible combinations, each combination gives a different tuition amount.
I have another table with my tuition amounts broken down, i have linked the "Status"; "Program" and "International" fields in this table to the previous table with my students.
How do i set up a field that when i enter a student and i select the status, program and international, that it will pull the tuition amount from the other table??
also, i'm entering the tuition amounts per academic year, but my table of students doesn't indicate academic year, how do i make it choose the most recent academic year tuition?