When specifying the details for you Program value list, did you select the "Show only related values" option?
Did you select "starting from" the student table?
Thanks for the quick reply.
When I set the Program value list to "show related values" and use the Student table as the start from,
the program dropdown box doesn't show anything - just a blank dropdown box, even though there is number
in the Faculty Code box.
I think I missed a detail in your first post...
You need a relationship between students and programs like this:
Students::ProgramID = FacultyByPrograms::ProgramID
where FacultyByPrograms is a second table occurrence of Faculty.
Then, you can Specify FacultyByPrograms instead of Faculty as the source of values and Show only related values starting from Students should work.
To create a "second table occurrence", select the Faculty box in Manage | Database | Relationships and then click the button with two green plus signs.