June 2, 200718 yr 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, 200718 yr by Guest
June 2, 200718 yr 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
Create an account or sign in to comment