AnsweredAssumed Answered

finding records with no related ones in a child table

Question asked by med on Oct 22, 2013
Latest reply on Oct 24, 2013 by philmodjunk

Title

finding records with no related ones in a child table

Post

     I have a student table and an appointment table and need to browse students with no future appointments. So this is what I did:

     I created a global field in the student table and assigned to it the current date. Then I related the appointment table to the student table with the following relation

     student::code = Appointment:: code  ( code is the student code)

     student::datefilter < appointment::date   (datefilter is the global field in student table and has the value of current date)

     Now when I try to perform a find to browse students with future booking I have no problem but when I try to find the ones without I tried:

     Appointment::date =

     or Appointment::date ?

     or appointment::date < today

     None of the above is working, what am I doing wrong?

      

Outcomes