Show field from parent depenting on another value..

[edudna]

Let we have a relation between teachers table and students table (0ne to many). Is it possible in a students layout to show automaticaly the name of the students teacher based on the selected class in both of tables? If the user selected the same class for teacher and for the student why have to complete the students' teacher field, this is the concept. How the relation the will be and calculated fields as well?

Pascal

Edited June 2, 2007 by Guest

[Søren Dyhr]

Frankly do you have too few tables, this is a classic setup many2many - and forget the nifty pilcrow delimited list until you have gotten these relations right!

Try to watch this video:

http://www.filemakermagazine.com/videos/graph-rules-four-rules-to-remember.html

--sd