I am working on FMpro10 on windows xp. I have two tables that are related "current students" and "faculty". On the student table I have a field "advisor". What I would like to do is have "advisor" in the student table = "full name" in the faculty table so that the "name ID" in the student table will fill in the "students" on the faculty table. I want to be able to have the db figure out who is whom's advisor from the student table and record it in the faculty table.
Any suggestions on how to build this lookup?