AnsweredAssumed Answered

Complex lookup

Question asked by sayzgor on Apr 15, 2010
Latest reply on Apr 26, 2010 by philmodjunk

Title

Complex lookup

Post

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?

Outcomes